topic Re: C# ArcObjects Oracle Connection string in ArcObjects SDK Questions

C# ArcObjects Oracle Connection string

JordanBaumgardner — Mon, 04 Aug 2014 16:01:08 GMT

Arrrg! I'm having a terrible time translating this connection string, would someone mind taking a stab at it?

Working connection in everything else:

//public string connectString = "SERVER=11.111.11.111;DATABASE=ABCDE;PORT=5121;USER=sde;PASSWORD=password;VERSION=SDE.DEFAULT";

Don't work:

IPropertySet connectionProps = new PropertySet();

connectionProps.SetProperty("dbclient", "Oracle11g");

connectionProps.SetProperty("server", "11.111.11.123"); // Also tried: [11.111.11.123:5121 | 11.111.11.123:5121/ABCDE]

connectionProps.SetProperty("instance", "5121"); // Also tried [11.111.11.123:5121/ABCDE | 11.111.11.123:5121 | "" ]

connectionProps.SetProperty("database", "ABCDEF"); // Also tried [ "" | "SDE" ]

connectionProps.SetProperty("version", "sde.DEFAULT");

connectionProps.SetProperty("user", "SDE");

connectionProps.SetProperty("password", "password");

return workspaceFactory.Open(connectionProps, 0);

I've tried every bloody combination I can think of.

I usually get "Entry for SDE instance not found in services file"

"Network I/O error"

"SDE not running on server"

Thanks in advance!

Re: C# ArcObjects Oracle Connection string

AdamFeidt — Mon, 04 Aug 2014 16:35:32 GMT

This worked for me: FYI...Direct Oracle Connection.

    private IGxDatabase2 pGXdb2;


                IPropertySet pPropset = default(IPropertySet);
                IWorkspaceName pInWorkspaceName = default(IWorkspaceName);
                string tInProgID = null;

                pPropset = new PropertySet();
                //create a propertyset using specified settings
                var _with3 = pPropset;
                _with3.SetProperty("SERVER", "");
                _with3.SetProperty("INSTANCE", "sde:oracle11g:ABCDEF");
                _with3.SetProperty("DATABASE", "");
                _with3.SetProperty("USER", "sde");
                _with3.SetProperty("PASSWORD", "password");
                _with3.SetProperty("VERSION", "SDE.DEFAULT");

pGXdb2 = null;

                // Create the source workspace name.
                pInWorkspaceName = new WorkspaceNameClass();
                pInWorkspaceName.ConnectionProperties = pPropset;

tInProgID = "esriDataSourcesGDB.SdeWorkspaceFactory";
pInWorkspaceName.WorkspaceFactoryProgID = tInProgID;

pGXdb2 = new GxDatabaseClass();
pGXdb2.WorkspaceName = pInWorkspaceName;

pGXdb2.Connect();

Adam

Re: C# ArcObjects Oracle Connection string

RiyasDeen — Tue, 05 Aug 2014 02:35:30 GMT

My recommendation would be to establish connection to your DB in arc catalogue, test the connection.

If test succeeds then pick up your .sde file found @

C:\Users\<<user name>>\AppData\Roaming\ESRI\Desktop10.2\ArcCatalog (windows 7)

Below code establishes connection using the sde file and returns a feature class.

public IFeatureClass GetSdeFeatureClass(string featureClassName)

{

IFeatureClass featureClass = null;

IWorkspaceFactory workspaceFactory = null;

IFeatureWorkspace destinationWorkspace = null;

try

{

workspaceFactory = new SdeWorkspaceFactoryClass();

destinationWorkspace = (IFeatureWorkspace)workspaceFactory.OpenFromFile(<<Path to your sde file>>, 0);

featureClass = destinationWorkspace.OpenFeatureClass(featureClassName);

}

catch (Exception ex)

{

throw ex;

}

finally

{

DisposeComObjects(workspaceFactory);

DisposeComObjects(destinationWorkspace);

}

return featureClass;

}

Re: C# ArcObjects Oracle Connection string

SusannSchmidt — Thu, 07 Aug 2014 12:30:00 GMT

I figthed the same war a few months ago and this is working for me:

string sid="orcl_dbname"; // from tnsnames.ora

IPropertySet connectionProps = new PropertySetClass();

connectionProps.SetProperty("SERVER", sid);

connectionProps.SetProperty("SERVERINSTANCE", "sde:oracle11g:/;LOCAL="+sid);

connectionProps.SetProperty("DATABASE", "");

connectionProps.SetProperty("DBCLIENT", "oracle");

connectionProps.SetProperty("db_connection_properties", sid);

connectionProps.SetProperty("AUTHENTICATION_MODE", "DBMS");

connectionProps.SetProperty("USER", user);

connectionProps.SetProperty("PASSWORD", password);

So good luck!

Re: C# ArcObjects Oracle Connection string

JordanBaumgardner — Mon, 11 Aug 2014 18:13:48 GMT

Thank you all, I tried Riyas' solution first as it looked the easiest, but I think all of your answers would have solved my issue. Thanks again to all.

Re: C# ArcObjects Oracle Connection string

KennethDinsmore — Wed, 15 Aug 2018 20:17:36 GMT

If you need the same application to connect to Oracle and SQL Server, you can put the property values in your app.config file and read them from the application. The appsettings section would look something like this for an oracle instance with a sid of "orcl":

While the same appsettings section for SQL Server might look like this: