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?
أكثر...
// 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?
أكثر...