FDO OGR-Driver 3.4.0 Connecting to PostGIS 8.2 with AutoCAD Map 3d 2010 fails

7 messages Options
Embed this post
Permalink
Hermann Karl

FDO OGR-Driver 3.4.0 Connecting to PostGIS 8.2 with AutoCAD Map 3d 2010 fails

Reply Threaded More More options
Print post
Permalink
Some javascript/style in this post has been disabled (why?)
FDO OGR-Driver 3.4.0 Connecting to PostGIS 8.2 with AutoCAD Map 3d 2010 fails

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.buttonLogin_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


_______________________________________________
fdo-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-users
Traian Stanev

RE: FDO OGR-Driver 3.4.0 Connecting to PostGIS 8.2 with AutoCAD Map 3d 2010 fails

Reply Threaded More More options
Print post
Permalink
Some javascript/style in this post has been disabled (why?)
FDO OGR-Driver 3.4.0 Connecting to PostGIS 8.2 with AutoCAD Map 3d 2010 fails

 

The GDAL DLL that comes with FDO is not compiled with the PostGIS driver by default – try replacing it by the GDAL dll that you are using with ogr2ogr (which presumably has the driver). You will also need libpq.dll and some other supporting PostGIS dlls.

 

Traian

 

 

From: [hidden email] [mailto:[hidden email]] On Behalf Of Hermann Karl
Sent: Monday, September 28, 2009 6:16 AM
To: FDO Users Mail List
Subject: [fdo-users] FDO OGR-Driver 3.4.0 Connecting to PostGIS 8.2 with AutoCAD Map 3d 2010 fails

 

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.buttonLogin_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


_______________________________________________
fdo-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-users
Hermann Karl

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

Reply Threaded More More options
Print post
Permalink
Some javascript/style in this post has been disabled (why?)
FDO OGR-Driver 3.4.0 Connecting to PostGIS 8.2 with AutoCAD Map 3d 2010 fails
Hi Traian,
 
Tried the gdal16.dll with all dependencies from OSGEO4W
The FDO OGR 3.4.0 connection form is not displayed
 
Tried the gdal16.dll with all dependencies from gdalwin32exe160
The FDO OGR 3.4.0 connection form ist displayed
PostGIS connection is not possible
 
Even with the gdal16.dll with all dependencies from fdo-win32-3.4.1
a PostGIS connection can not be established.
 
Any Idea ?
 
Thanks
 
Karl


Von: [hidden email] [mailto:[hidden email]] Im Auftrag von Traian Stanev
Gesendet: Montag, 28. September 2009 16:34
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

 

The GDAL DLL that comes with FDO is not compiled with the PostGIS driver by default – try replacing it by the GDAL dll that you are using with ogr2ogr (which presumably has the driver). You will also need libpq.dll and some other supporting PostGIS dlls.

 

Traian

 

 

From: [hidden email] [mailto:[hidden email]] On Behalf Of Hermann Karl
Sent: Monday, September 28, 2009 6:16 AM
To: FDO Users Mail List
Subject: [fdo-users] FDO OGR-Driver 3.4.0 Connecting to PostGIS 8.2 with AutoCAD Map 3d 2010 fails

 

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.buttonLogin_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


_______________________________________________
fdo-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-users
Frank Warmerdam

Re: FDO OGR-Driver 3.4.0 Connecting to PostGIS 8.2 with AutoCAD Map 3d 2010 fails

Reply Threaded More More options
Print post
Permalink
In reply to this post by Hermann Karl
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.buttonLogin_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, [hidden email]
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
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-users
Hermann Karl

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

Reply Threaded More More options
Print post
Permalink
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: [hidden email] [mailto:[hidden email]] 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, [hidden email]
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
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-users
_______________________________________________
fdo-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-users
Gwenael Bachelot

RE: FDO OGR-Driver 3.4.0 Connecting to PostGIS 8.2 withAutoCAD Map 3d 2010 fails

Reply Threaded More More options
Print post
Permalink
Hi Hermann,

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

Cordialement,
Gwenael
---------------------------------------
Gwenael Bachelot - Mailto:[hidden email]
http://blogs.autodesk.com/geospatialfrance

-----Original Message-----
From: [hidden email] [mailto:[hidden email]] 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: [hidden email] [mailto:[hidden email]] 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, [hidden email]
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
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-users
_______________________________________________
fdo-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-users
_______________________________________________
fdo-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-users
Hermann Karl

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

Reply Threaded More More options
Print post
Permalink
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: [hidden email] [mailto:[hidden email]] 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:[hidden email]
http://blogs.autodesk.com/geospatialfrance

-----Original Message-----
From: [hidden email] [mailto:[hidden email]] 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: [hidden email] [mailto:[hidden email]] 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, [hidden email]
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
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-users
_______________________________________________
fdo-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-users
_______________________________________________
fdo-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-users
_______________________________________________
fdo-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-users