Showing results for 
Search instead for 
Do you mean 

GeoMedia G/Technology data server connection error

by Technical Evangelist on ‎03-09-2016 05:53 AM - edited on ‎04-06-2016 11:58 AM by Moderator (845 Views)

Symptoms

GeoMedia G/Technology data server connection error "Unable to connect to the database. Please verify that your warehouse-connection parameters are correct and try again."

Diagnosis

When trying to connect to a G/Technology warehouse from GeoMedia using the G/Technology data server user gets the following error message:

"Unable to connect to the database. Please verify that your warehouse-connection parameters are correct and try again."

Solution

When trying to connect to G Tech from GeoMedia using the G/Technology data server user gets the following error message:

 

"Unable to connect to the database. Please verify that your warehouse connection parameters are correct and try again."

 

The user's warehouse-connection parameters are correct. When clicking the "More"-button in the error message dialog to get further information about the problem the dialog is empty. The problem is due to the "OraOLEDB11.dll" not being registered and doesn't have anything to do with the warehouse-connection parameters.

 

To manually register the "OraOLEDB11.dll" open a Windows Command Processor window and locate the "OraOLEDB11.dll" file on the system.

 

For example, it could be located at C:\Oracle\product\11.2.0\client_1\BIN. It just depends where Oracle client was installed on the machine.

Then key in "resvr32 OraOLEDB11.dll" to register the .dll.

Comments
by
on ‎03-08-2020 11:13 PM

PClient.Connection conn = new PClient.Connection();

conn = (PClient.Connection)this._currentApplication.CreateService("GeoMedia.Connection");
conn.Name = "WMS";
conn.Type = "WMS.Gdatabase";
conn.Mode = PClient.ConnectionConstants.gmcModeReadOnly;
conn.Description = "WMS";
conn.Location = "not used";
conn.ConnectInfo = @"NOCSFFOUND=FAIL;URI= "wms url";
conn.Connect();

 

I am also unable to connect and getting this error :  "Unable to connect to the database. Please verify that your warehouse-connection parameters are correct and try again."

Can somebody please provide the solution?

 

Thank you !

Rutuparna