[mapguide-users] PostGIS on MGOS

[Maciej Skorczewski]

> How do I connect POSTGIS on MGOS.The default FDO connectors does allow 
> ODBC – will I need to connect ODBC to PostgreSQL?

1.Download Ogr provider (or PostGIS provider - not ready...but it will 
be soon)
http://fdo.osgeo.org/


2.Extract it to
C:\Program Files\MapGuideOpenSource\Server\Bin\FDO


3. Edit providers.xml file in
C:\Program Files\MapGuideOpenSource\Server\Bin\FDO

Add this entry (this is for MG 1.2.0 Beta 2)

<FeatureProvider>
     <Name>OSGeo.OGRProvider.3.2</Name>
     <DisplayName>OGR </DisplayName>
     <Description>Read/write access to an ESRI ArcSDE-based data store, 
using Oracle and SQL Server. </Description>
     <IsManaged>False</IsManaged>
     <Version>3.2.2</Version>
     <FeatureDataObjectsVersion>3.2.2.0</FeatureDataObjectsVersion>
     <LibraryPath>OGRProvider.dll</LibraryPath>
   </FeatureProvider>


4. Restart MG server...it all will be ok you can chose  in Studio new 
provider in New DataConnection


in data connection string type:

PG: host=localhost user=postgres dbname=dbname password=your_pass
TRUE



thats all



Maciej Skorczewski