I have an Oracle11g database that I connect to via a SQL Workspace; however the actual dbclient string value that works differs depending on machine (and I'm guessing oracle client configuration). On some machines, its Oracle11g
(like the example on resources.arcgis.com):
// Create the connection properties.
IPropertySet connectionProps = new PropertySetClass();
connectionProps.SetProperty("dbclient", "Oracle11g");
connectionProps.SetProperty("serverinstance", "Riverside");
connectionProps.SetProperty("authentication_mode", "DBMS");
connectionProps.SetProperty("user", "BlackDog");
connectionProps.SetProperty("password", "123456");
Sometimes it's Oracle
.
// Create the connection properties.
IPropertySet connectionProps = new PropertySetClass();
connectionProps.SetProperty("dbclient", "Oracle");
connectionProps.SetProperty("serverinstance", "Riverside");
connectionProps.SetProperty("authentication_mode", "DBMS");
connectionProps.SetProperty("user", "BlackDog");
connectionProps.SetProperty("password", "123456");
How is that dbclient value used by ArcGIS? Is there a way to detect which is needed at runtime?
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=lorem)(PORT=1521)))(CONNECT_DATA=(SID=ipsum)))
. I prefer this option since the actual address name differs from machine to machine. – Jay Cummins Jul 22 '14 at 13:38tnsping
s work fine, so I wasn't initially thinking it was tns related. – Jay Cummins Jul 22 '14 at 13:42