C# ArcObjects Oracle Connection string

JordanBaumgardner

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"

or

"Network I/O error"

or

"SDE not running on server"

Thanks in advance!

RiyasDeen

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;

        }