[mapguide-users] OGR with postgis support

[Kenneth, GEOGRAF A/S]

I haven't tried anything using SQL server, but I can't imagine that 
there should any problems when connecting through ODBC.

Mvh. Kenneth, GEOGRAF A/S




kenny at keniginc.com skrev:
> Thanks very much, Kenneth!
>
> I got it now.
>
> Just one related question. Are we still unable to connect to sql 
> server db using ODBC?
>
> Quoting "Kenneth, GEOGRAF A/S" <ks at geograf.dk>:
>
>> There is an FDO folder for Studio in C:\Program
>> Files\Autodesk\MapGuideStudio2007\FDO.
>> There is an FDO folder for MgServer in C:\Program
>> Files\Autodesk\MapGuideEnterprise2007\Server\Bin\FDO.
>>
>> Correct the above paths to your system.
>>
>> You must copy the OGRProvider.dll to both folders above, and edit the
>> providers.xml in both folders.
>> If you use MapGuide OS, it has recently shifted to FDO 3.2, and you
>> have to change the version number in providers.xml.
>> If you use MapGuide EP, you must build OGR provider, using an older FDO
>> snapshot, otherwise it won't load.
>>
>> After restarting the service and studio, you should be able to select
>> New -> Data connection...
>>
>> On the list you should now see "OSGeo FDO Provider for OGR"
>>
>> I hope you are working on windows, as you will have to compile a
>> .dll/.so for both windows and linux otherwise.
>>
>> Mvh. Kenneth, GEOGRAF A/S
>>
>>
>>
>> kenny at keniginc.com skrev:
>>> Hi Kenneth and thank you for responding to this thread.
>>>
>>> How do you edit the providers.xml?
>>>
>>> It is my understanding that from the readme associated with the ogr 
>>>  provider that I downloaded that you need to do 2 things:
>>>
>>> 1, add an entry, this entry:
>>>
>>>  <FeatureProvider>
>>>    <Name>OSGeo.OGR.0.1</Name>
>>>    <DisplayName>FDO Provider for OGR</DisplayName>
>>>    <Description>Access to OGR data sources</Description>
>>>    <IsManaged>False</IsManaged>
>>>    <Version>0.1.0.0</Version>
>>>    <FeatureDataObjectsVersion>3.1.0.0</FeatureDataObjectsVersion>
>>>    <LibraryPath>OGRProvider.dll</LibraryPath>
>>>   </FeatureProvider>
>>>
>>> to providers.xml and as you correctly stated, add the OGRprover.dll 
>>>  into FDO.
>>>
>>> I have done these and restarted the mapGuide service.
>>>
>>> If all goes well, when you go to Studio and attempt to add a  
>>> database connection, you should the OGR provider. Right now, I only 
>>>  see the ODBC connection that I set up awhile back.
>>>
>>> Did I miss something?
>>>
>>> Quoting "Kenneth, GEOGRAF A/S" <ks at geograf.dk>:
>>>
>>>> You must edit providers.xml and copy the dll into the FDO directory.
>>>> This must be done in both the Service FDO folder and the Studio FDO 
>>>> folder.
>>>>
>>>> I'm guessing that Studio uses the GUI part, and the Service does the
>>>> actual data access.
>>>>
>>>> Perhaps Studio should be modified to load this from the server?
>>>> But then there would be windows/linux problems.
>>>>
>>>> I don't know how this works in Web Studio, if thats what you are 
>>>> trying.
>>>>
>>>> Mvh. Kenneth, GEOGRAF A/S
>>>>
>>>>
>>>>
>>>> kenny at keniginc.com skrev:
>>>>> Ok,
>>>>>
>>>>> I know I have been a bit slower catching on to this than most,   
>>>>> largely because other extreme commitments but please bear with me.
>>>>>
>>>>> I just downloaded, unzipped and compiled OGR Provider with  
>>>>> PostGIS  support so I can gain direct access to some of our files 
>>>>>  using  connections.
>>>>>
>>>>> After adding an entry to providers.xml, I restarted service, wen  
>>>>> to  studio and database connection but it isn't there.
>>>>>
>>>>> What am I doing wrong?
>>>>>
>>>>> Thanks very much in advance
>>>>>
>>>>> ---------------------------------------------------------------------
>>>>> 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
>>>
>>>
>>>
>>> ---------------------------------------------------------------------
>>> 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
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
> For additional commands, e-mail: users-help at mapguide.osgeo.org
>