AW: [fdo-users] FDO OGR-Driver 3.4.0 Connecting to PostGIS 8.2withAutoCAD Map 3d 2010 fails

[Hermann Karl]

Dear Gwenael,

I tried to find out if the fdo ogr driver enables the use of the bulk copy function of autocad map 3d 2010
to import a esri-shape to postgis without the need to create the target table in postgis before.
The result is that it is not possible.
On the other hand i want to test the possibility of the utilization the complete functionality of the ogr/gdal library.

Best regards

Karl
 

-----Ursprüngliche Nachricht-----
Von: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-bounces at lists.osgeo.org] Im Auftrag von Gwenael Bachelot
Gesendet: Dienstag, 29. September 2009 16:31
An: FDO Users Mail List
Betreff: RE: [fdo-users] FDO OGR-Driver 3.4.0 Connecting to PostGIS 8.2withAutoCAD Map 3d 2010 fails

Hi Hermann,

Out of curiousity, why using FDO OGR instead of native FDO PostGIS ?

Cordialement,
Gwenael
---------------------------------------
Gwenael Bachelot - Mailto:gwenael.bachelot at autodesk.com
http://blogs.autodesk.com/geospatialfrance

-----Original Message-----
From: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of Hermann Karl
Sent: mardi 29 septembre 2009 16:17
To: FDO Users Mail List
Subject: AW: [fdo-users] FDO OGR-Driver 3.4.0 Connecting to PostGIS 8.2 withAutoCAD Map 3d 2010 fails

Hi Frank,

Thanks for your reply.

If the gdal16.dll  in the FDO/bin directory of AutoCAD Map 3d 2010 which is without PostgreSQL support is replaced with

\release-1500-gdal-1-6-mapserver-5-4\bin\GDAL16.DLL
\release-1500-gdal-1-6-mapserver-5-4\bin\GEOS_C.DLL
\release-1500-gdal-1-6-mapserver-5-4\bin\LIBCURL.DLL
\release-1500-gdal-1-6-mapserver-5-4\bin\LIBEXPAT.DLL
\release-1500-gdal-1-6-mapserver-5-4\bin\LIBPQ.DLL
\release-1500-gdal-1-6-mapserver-5-4\bin\SQLITE3.DLL
\release-1500-gdal-1-6-mapserver-5-4\bin\XERCES-C_2_8.DLL

from

http://vbkto.dyndns.org/sdk/

the OGR connect to PostGIS will work

http://geospatialfrance.typepad.com/geospatialfrance/2007/09/accs-natif-post.html

Best regards,

Karl



-----Ursprüngliche Nachricht-----
Von: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-bounces at lists.osgeo.org] Im Auftrag von Frank Warmerdam
Gesendet: Montag, 28. September 2009 18:43
An: FDO Users Mail List
Betreff: Re: [fdo-users] FDO OGR-Driver 3.4.0 Connecting to PostGIS 8.2 withAutoCAD Map 3d 2010 fails

Hermann Karl wrote:
> Dear List,
> 
> trying to connect to PostGIS 8.2 from AutoCAD Map 3d 2010 with 
> connectionstring
> 
> PG:"dbname=databasename host=localhost port=5432 user=x password=y"
> 
> following error message is launched
> 
> OSGeo.FDO.Common.Execption: Connect failed:
>  bei OSGeo.FDO.Connections.IConnectionImp.Open()
>  bei
> Autodesk.Gis.Map.DataConnect.Plugins.GenericProviderConnectionPlugin.b
> uttonLogin_Click(Object
> sender, EventArgs e)
> 
> in the readme of the FDO OGR-driver 3.4.0 there is following comment:
> 
> So far the OGR provider has been (successfully) tested with:
>     * SHP files
>     * MapInfo files (.TAB)
>     * Oracle Spatial
>     * ESRI personal geodatabase (.mdb)
>     * PostGIS (on PostgreSQL 8.1.4)
> 
> the commandlinetools ogr2ogr or ogrinfo work with this connection 
> syntax

Karl,

OGR is not built with postgresql support by default and I suspect the OGR driver you have lacks it.  You can test the GDAL/OGR dll with depends.exe (if you have it) to see if it has a dependency on the libpq.dll (the postgres client library).

Best regards,
-- 
---------------------------------------+--------------------------------
---------------------------------------+------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | Geospatial Programmer for Rent

_______________________________________________
fdo-users mailing list
fdo-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/fdo-users
_______________________________________________
fdo-users mailing list
fdo-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/fdo-users
_______________________________________________
fdo-users mailing list
fdo-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/fdo-users