AW: [fdo-users] AutoCAD Map 3d 2011 PostgreSQL FDO-ProviderConnection to PostGreSQL-8.4.3-1 PostGIS 1.4.2 fails

[Hermann Karl]

Hi Greg,
 
Thanks for your reply.
 
In the FDO PostgreSQL connection dialog window of AutoCAD map 3d 2011 service is defined as host:port (localhost:5432). In the FDO Toolbox PostgreSQL connection dialog window service is defined wíth database at host:port (gisdb at localhost:543)
When I copy the ssleay32.dll and the libeay32.dll from the ....\PostgreSQL\8.4\bin directory in the ...\FDO\bin directory the FDOPostGreSQL Provider connection dialog in AutoCAD Map 3d 2011
results in the message that the connection is not possible.
When the dlls are copied in C:\windows\system32 the connection to the PostgreSQL-8.4.3-1 PostGIS 1.4.2 works.
 
Karl

________________________________

Von: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-bounces at lists.osgeo.org] Im Auftrag von Greg Boone
Gesendet: Freitag, 23. April 2010 21:11
An: FDO Users Mail List
Betreff: RE: [fdo-users] AutoCAD Map 3d 2011 PostgreSQL FDO-ProviderConnection to PostGreSQL-8.4.3-1 PostGIS 1.4.2 fails



>From a previous post:

 

 

The PostgreSQL provider handles the connection a bit differently [than the PostGIS Provider]. It maps the FDO datastore to a PostgreSQL database, and then exposes all the schemas that are present. Try the following for service and datastore:

 

objConnProp.SetProperty("Service", < server:port>) objConnProp.SetProperty("DataStore", <DBName>)

 

A fix was made to the trunk to improve the connection error message (show the error generated by the PostgreSQL server). However, this will not show up until the next version after FDO 3.5

 

Are you setting Service and DataStore properly?

Are the PostgreSQL client binaries in the same directory as the FDO DLLs?

 

Greg

 

From: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of Hermann Karl
Sent: Friday, April 23, 2010 12:06 PM
To: fdo-users at lists.osgeo.org
Subject: [fdo-users] AutoCAD Map 3d 2011 PostgreSQL FDO-Provider Connection to PostGreSQL-8.4.3-1 PostGIS 1.4.2 fails

 

Dear List, 

With the PostgreSQL FDO Provider in AutoCAD Map 3d 2011 I am not able to connect to a 
PostGreSQL-8.4.3-1 PostGIS 1.4.2 database 

The service is on localhost:5432 or 127.0.0.1:5432 

Karl 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/fdo-users/attachments/20100426/103749e1/attachment.html