[mapguide-users] OGR with postgis support

[Kenneth, GEOGRAF A/S]

Yes, thats what it looks like.

In the DataSource field, you must type the OGR connections string.
For starters, you should try to set ReadOnly to true

Mvh. Kenneth, GEOGRAF A/S
ks at geograf.dk
tlf: +45 48 16 67 14



kenny at keniginc.com skrev:
> Guys,
>
> I have tried to use the OGR Provider and it isn't working.
>
> I am attaching a screenshot.  Is it supposed to look like this?
>
> Quoting "Kenneth, GEOGRAF A/S" <ks at geograf.dk>:
>
>> 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
>>>
>>
>> ---------------------------------------------------------------------
>> 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
-------------- next part --------------
Skipped content of type multipart/related