[mapguide-users] postgresql connection with ogr/odbc

[joanne cook]

I look forward to it. We are very keen to use postgresql as a backend for both our desktop and web-based gis so this is a real bonus.
 
Jo
 
-------------------------------------------
Joanne Cook BSc MLitt AIFA
Information Systems Coordinator
Oxford Archaeology North
-------------------------------------------

________________________________

From: Traian Stanev [mailto:traian.stanev at autodesk.com]
Sent: Wed 21/06/2006 19:25
To: joanne cook
Cc: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] postgresql connection with ogr/odbc




Nice to get an independent confirmation that something works :)
One thing to watch out for that definitely does not work with the OGR
provider is selection of features if you are using the AJAX viewer. This
is because I haven't added support for Intersects queries yet. I hope to
have it soon.

Traian


-----Original Message-----
From: joanne cook [mailto:j.cook at oxfordarch.co.uk]
Sent: Wednesday, June 21, 2006 4:59 AM
To: Traian Stanev
Cc: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] postgresql connection with ogr/odbc

Hi Traian,

Many thanks for this- it works fine with a larger dataset. This is
great! For information- the connection string I needed to use was:
PG: host=hostname user=username dbname=dbname password=password

Thanks again

Jo


-------------------------------------------
Joanne Cook BSc MLitt AIFA
Information Systems Coordinator
Oxford Archaeology North
-------------------------------------------

________________________________

From: Traian Stanev [mailto:traian.stanev at autodesk.com]
Sent: Tue 20/06/2006 18:02
To: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] postgresql connection with ogr/odbc




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