[mapguide-users] postgresql connection with ogr/odbc

[Traian Stanev]

I posted a Win32 build of the OGR provider with PostGIS support over
here:

https://mapguide.osgeo.org/files/documents/12/184/OGRProvider_win32_pq.z
ip


It worked in MapGuide for my (small) test data set of 12 polygons :)
The needed OGR connection string is somewhat byzantine and has the form
described in the OGR documentation at:

http://www.remotesensing.org/gdal/ogr/drv_pg.html


Traian
 

-----Original Message-----
From: Traian Stanev 
Sent: Tuesday, June 20, 2006 9:24 AM
To: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] postgresql connection with ogr/odbc



Are you using the posted Windows DLL? The posted OGR provider binary is
compiled against a GDAL/OGR without Postgres support (since I didn't
have the required libraries for Pq). It would need to be recompiled with
an OGR that has Postgres support for it to have a chance of working.


Traian
 

-----Original Message-----
From: joanne cook [mailto:j.cook at oxfordarch.co.uk] 
Sent: Tuesday, June 20, 2006 8:22 AM
To: users at mapguide.osgeo.org
Subject: [mapguide-users] postgresql connection with ogr/odbc

Hi List,
 
Should I be able to connect to postgresql data sources with either the
ogr or odbc connectors? I have tried with both and got the same error
message when I try and test the connection: 
 
System.Net.WebException: The remote server returned an error: (559)
MgFdoException.
   at
Autodesk.MapGuide.Studio.Site.Comm.RequestManager.ExecutePendingGetReque
stToString(Operation operation)
   at
Autodesk.MapGuide.Studio.Site.Comm.RequestManager.TestConnection(String
resourceId, String provider, String connectionString)
   at Autodesk.MapGuide.Studio.Site.FeatureSourceInfo.TestConnection()
   at
Autodesk.MapGuide.Studio.UI.FeatureSourceEditors.TestConnectionControl.b
uttonTestConnection_Click(Object sender, EventArgs e)
 
Thanks
 
Jo
 
-------------------------------------------
Joanne Cook BSc MLitt AIFA
Information Systems Coordinator
Oxford Archaeology North
-------------------------------------------


This message has been scanned for viruses by BlackSpider MailControl -
www.blackspider.com

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
For additional commands, e-mail: users-help at mapguide.osgeo.org




---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
For additional commands, e-mail: users-help at mapguide.osgeo.org