Need help to connect postgresql using ESRI.ArcGIS.Geodatabase.IWorkspaceFactory2.OpenFromString method

VeeramaniB — Mon, 04 Oct 2021 10:58:09 GMT

Hello Team,

I need a help to connect geodatabase using ESRI.ArcGIS.Geodatabase.IWorkspaceFactory2.OpenFromString method

I coded like below (I have pasted only necessary part of code where i have issue)

I am getting below print statements from my Log file, after that not getting and DB connection also not established.

ErrorHandling.WriteStatusMessage("CommandManager_LoadSde", "Open SDE workspace");
ErrorHandling.WriteStatusMessage("Connection String", gConnectionString);

ESRI.ArcGIS.Geodatabase.IWorkspaceFactory2 pFact = null;
pFact = (ESRI.ArcGIS.Geodatabase.IWorkspaceFactory2)new ESRI.ArcGIS.DataSourcesGDB.SdeWorkspaceFactory();
ESRI.ArcGIS.Geodatabase.IWorkspace pWorkspace = null;

String gConnectionString = "DBCLIENT=postgresql"
+ "SERVER=" + "<serverIP address>"
+ ";DATABASE=" + "<DBName>"
+ ";INSTANCE=" + "<port>"
+ ";USER=" + <user>
+ ";PASSWORD=" + <pwd>
+ ";VERSION=sde.DEFAULT";

ErrorHandling.WriteStatusMessage("CommandManager_LoadSde", "Open SDE workspace");
ErrorHandling.WriteStatusMessage("Connection String", gConnectionString);

// PJD DEBUG:
//System.Windows.Forms.MessageBox.Show("gConnectionString is: " + gConnectionString);

pWorkspace = MemoryHelper.ReleaseAndCleanObject<ESRI.ArcGIS.Geodatabase.IWorkspace>(pWorkspace, pFact.OpenFromString(gConnectionString, 0));

System.Diagnostics.Debug.WriteLine("CommandManager_LoadSde", "Setting Workspace path=" + pWorkspace.PathName);

pPropertySet.SetProperty("WORKSPACE", pWorkspace);

//Set property and execute load sde command
clsLoadSdeSource pLoadSdeSource = MapTools.MapToolsFactory.Create<clsLoadSdeSource>(null, false);
pLoadSdeSource.LayerConfig = pPropertySet;
pLoadSdeSource.SdeWorkspace = pWorkspace;
ErrorHandling.WriteStatusMessage("CommandManager_LoadSde", "Call loadSdeSource.execute");

Please help me to fix this issue.

Thanks!

topic Need help to connect postgresql using ESRI.ArcGIS.Geodatabase.IWorkspaceFactory2.OpenFromString method in Geodatabase Questions

Need help to connect postgresql using ESRI.ArcGIS.Geodatabase.IWorkspaceFactory2.OpenFromString method