FDO OGR Provider for PostGreSQL 8.3 + PostGis

[psergio]

Some javascript/style in this post has been disabled (why?)

Hi all,

I'm trying to connect Mapguide OS 2.0.2 with a PostGreSQL 8.3 + PostGis database via FDO OGR Provider 3.3.0.
I have downloaded the provider dll from OSGeo Website, and put them in the MapGuideOpenSource2.0\Server\Bin\FDO folder and updated the providers.xml file.
After that i try to create a DataConnection in MapGuide Maestro, selected the OSGeo  FDO Provider for OGR then i fill the DataSource field whith  PG:host=myHost dbname=myDBName user=myUser password=myPassword port=5432 (this are fake names) and the Readonly field with TRUE, but when i press the Test connection button occurs the following error:

The remote server returned an error: (559) MgFdoException.:
An exception occurred in FDO component.
Connect failed:
Exception occurred in method MgFdoConnectionManager.Open at line 858 in file d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\common\manager\FdoConnectionManager.cpp

Did i forget some step or DLL?

Thanks for your time!

Best regards,
Paulo







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

[Traian Stanev]

Some javascript/style in this post has been disabled (why?)

 

This is probably because the default GDAL/OGR dll available with FDO does not include GDAL support. You can try using this provider DLL:

 

http://13-9.com/OGRProvider-3.3.0.zip

 

It is static-linked to a GDAL that’s compiled with Postgres support. Note that it requires that the libpq.dll (the PostgresSQL support dll) be somewhere in the system path.

 

Traian

 

 

From: [hidden email] [mailto:[hidden email]] On Behalf Of Paulo Azevedo
Sent: Wednesday, February 04, 2009 12:17 PM
To: [hidden email]; [hidden email]; [hidden email]
Subject: [fdo-users] FDO OGR Provider for PostGreSQL 8.3 + PostGis

 

Hi all,

I'm trying to connect Mapguide OS 2.0.2 with a PostGreSQL 8.3 + PostGis database via FDO OGR Provider 3.3.0.
I have downloaded the provider dll from OSGeo Website, and put them in the MapGuideOpenSource2.0\Server\Bin\FDO folder and updated the providers.xml file.
After that i try to create a DataConnection in MapGuide Maestro, selected the OSGeo  FDO Provider for OGR then i fill the DataSource field whith  PG:host=myHost dbname=myDBName user=myUser password=myPassword port=5432 (this are fake names) and the Readonly field with TRUE, but when i press the Test connection button occurs the following error:

The remote server returned an error: (559) MgFdoException.:
An exception occurred in FDO component.
Connect failed:
Exception occurred in method MgFdoConnectionManager.Open at line 858 in file d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\common\manager\FdoConnectionManager.cpp

Did i forget some step or DLL?

Thanks for your time!

Best regards,
Paulo

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

[psergio]

Some javascript/style in this post has been disabled (why?)

Hello Traian.

Thanks for the fast reply.
This solution work for me.

Many thanks.

Paulo



Traian Stanev wrote:

 

This is probably because the default GDAL/OGR dll available with FDO does not include GDAL support. You can try using this provider DLL:

 

http://13-9.com/OGRProvider-3.3.0.zip

 

It is static-linked to a GDAL that’s compiled with Postgres support. Note that it requires that the libpq.dll (the PostgresSQL support dll) be somewhere in the system path.

 

Traian

 

 

From: [hidden email] [[hidden email]] On Behalf Of Paulo Azevedo
Sent: Wednesday, February 04, 2009 12:17 PM
To: [hidden email]; [hidden email]; [hidden email]
Subject: [fdo-users] FDO OGR Provider for PostGreSQL 8.3 + PostGis

 

Hi all,

I'm trying to connect Mapguide OS 2.0.2 with a PostGreSQL 8.3 + PostGis database via FDO OGR Provider 3.3.0.
I have downloaded the provider dll from OSGeo Website, and put them in the MapGuideOpenSource2.0\Server\Bin\FDO folder and updated the providers.xml file.
After that i try to create a DataConnection in MapGuide Maestro, selected the OSGeo  FDO Provider for OGR then i fill the DataSource field whith  PG:host=myHost dbname=myDBName user=myUser password=myPassword port=5432 (this are fake names) and the Readonly field with TRUE, but when i press the Test connection button occurs the following error:

The remote server returned an error: (559) MgFdoException.:
An exception occurred in FDO component.
Connect failed:
Exception occurred in method MgFdoConnectionManager.Open at line 858 in file d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\common\manager\FdoConnectionManager.cpp

Did i forget some step or DLL?

Thanks for your time!

Best regards,
Paulo

_______________________________________________
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

[marco.paula]

psergio wrote:

Hello Traian.

 I'm try execute this method and substitute a OGR Provider and my error message is:

The remote server returned an error: (559) MgFdoException.:
An exception occurred in FDO component.
Unable to load the FDO Provider: Não foi possível encontrar o módulo especificado.
 
Exception occurred in method MgFdoConnectionManager.Open at line 262 in file d:\buildforgeprojects\mapguide_open_source_v2.0\build_23.8\mgdev\server\src\common\manager\FdoConnectionManager.cpp

my PostGres version is 8.2 and the PostGIS version is 1.3.1

Thanks..