AnsweredAssumed Answered

C# ArcObjects Oracle Connection string

Question asked by JordanBaumgardner_GIS on Aug 4, 2014
Latest reply on Aug 15, 2018 by KenDinsmore

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 ****** 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!

Outcomes