[mapguide-users] RE: OGR and MGOS

[Rahul]

Hi,
       I haven't checked OGR 3.2.2 for MySQL Connection as you already have  FDO Provider for MySQL-MySQLProvider.dll ,regrading the OGR 3.2.2 for the PostGIS database works Cool on the MGOS 1.2.0.
   
  I think you can try PostGIS Database with the below connection string --
   
  DataSource -----PG: host=xxxx port=xxxx dbname=xxxx user= xxx password=xxx
ReadOnly--------FALSE
   
  Edit in the providers.xml file--
   
  <FeatureProvider>
  <Name>OSGeo.OGR.3.2</Name>
  <DisplayName>OSGeo FDO Provider for OGR</DisplayName>
  <Description>Access to OGR Data Sources</Description>
  <IsManaged>False</IsManaged>
  <Version>3.2.2.0</Version>
  <FeatureDataObjectsVersion>3.2.2.0</FeatureDataObjectsVersion>
  <LibraryPath>F:\Program Files\MapGuideOpenSource\Server\Bin\FDO\OGRProvider.dll</LibraryPath>
  </FeatureProvider>
   
  Cheers
  Max !!
  
Dhirendra Kumar <dhirendra.mgos at gmail.com> wrote:
  
Hi Rahul-2,

Are you sure that OGR 3.2 and MGOS 1.2.0 will work fine and provide
connectivity with MySQL ? But MGOS 1.2.0 come with FDO 3.2.2.0 and OGR
provider also available in version OGR 3.2.2, So for MySQL connectivity i'll
have to reinstall FDO 3.2 with MGOS .1.2.0 ?. If you have any suggestion
then please replay me. I can establish connection MGOS 1.1.0 with MySQL
using default MySQL Provider but problem in Layer polygon selection, when i
select one polygon then another near polygon get highlighted and for this
resion my project get stuck. So i am searching another FDO provider like
postGIS or any good database that solve my problem. If you have any idea or
suggestion then help me. Thankyou in Advance.

Regards,

Dhirendra kumar

Rahul-2 wrote:
> 
> Hi ,
> I think you check your connection string ,it should be--
> 
> POSTGIS
> DataSource -----PG: host=xxxx port=xxxx dbname=xxxx user= xxx
> password=xxx
> ReadOnly--------FALSE
> 
> same kind of setting you can try for the MySQL.
> 
> DataSource -----PG:dbname=xxxx,user=
> xxx,password=xxx,host=xxxx,port=xxxx
> ReadOnly--------FALSE
> 
> I think OGR 3.2 doesn't work properly with MGOS 1.1 so try MGOS 1.2.0
> with FDO 3.2.0.
> 
> Cheers
> Max !!
> 
> nicholda wrote:
> 
> I have not tried this with MySql. The problems that was experiencing were
> with PostGis. I resolved it by trying the different OGR's available. I
> have
> attached the one that I am currently using for PostGis. I hope this helps. 
> Below is also the modifications that need to be made to the Providers.xml.
> 
> David
> 
> 
> OSGeo.OGRProvider.3.2 
> FDO Provider for OGR 
> Access to OGR data sources 
> False 
> 3.2.0.0 
> 3.2.0.0 
> 
> C:\Program
> Files\MapGuideOpenSource\Server\Bin\FDO\OGRProvider.dll 
> 
> 
> 
> 
> 
> Dhirendra Kumar wrote:
>> 
>> Hi Nicholda,
>> 
>> I am also using MGOS 1.1 and Mapguide Studio 07, and OGR 3.2 and i can
>> see
>> Datasource and Readonly property, but i can't establish connection with
>> MySQL Database. you have any idea about this then help me pls. i enter in
>> connection string in datasource is
>> MYSQL:westholland,user=root,password=psv9570,port=3306, but it is not
>> working. help me.
>> 
>> Regards, 
>> Dhirendra Kumar
>> 
>> 
>> nicholda wrote:
>>> 
>>> I am also using MGOS 1.1 and Mapguide Studio 07 6.5. I get a successful
>>> connection, but when I try to create a new layer from Postgres. I get
>>> the attached error message.
>>> 
>>> 
>>> 
>>> Traian Stanev wrote:
>>>> 
>>>> I've seen that happen with some builds of the provider -- Studio does
>>>> not display the connection properties. What version of MapGuide are you
>>>> using?
>>>> 
>>>> 
>>>> -----Original Message-----
>>>> From: mapguide-users-bounces at lists.osgeo.org
>>>> [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Rahul
>>>> Sent: Wednesday, May 16, 2007 3:05 AM
>>>> To: MapGuide Users Mail List
>>>> Subject: RE: [mapguide-users] OGR and MGOS
>>>> 
>>>> _______________________________________________
>>>> mapguide-users mailing list
>>>> mapguide-users at lists.osgeo.org
>>>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>>> http://lists.osgeo.org/mailman/listinfo/mapguide-users 
>>>> 
>>>> 
>>>> _______________________________________________
>>>> mapguide-users mailing list
>>>> mapguide-users at lists.osgeo.org
>>>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>>> http://lists.osgeo.org/mailman/listinfo/mapguide-users 
>>>> 
>>>> 
>>> http://www.nabble.com/file/p10663767/Error.JPG 
>>> 
>> 
>> 
> http://www.nabble.com/file/p11781363/OGRProvider.dll OGRProvider.dll 
> -- 
> View this message in context:
> http://www.nabble.com/OGR-and-MGOS-tf3728865s16610.html#a11781363
> Sent from the MapGuide Users mailing list archive at Nabble.com.
> 
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> 
> 
> 
> ---------------------------------
> Be a better Heartthrob. Get better relationship answers from someone who
> knows.
> Yahoo! Answers - Check it out. 
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> 
> 

-- 
View this message in context: http://www.nabble.com/OGR-and-MGOS-tf3728865s16610.html#a11805486
Sent from the MapGuide Users mailing list archive at Nabble.com.

_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users


       
---------------------------------
Get the Yahoo! toolbar and be alerted to new email wherever you're surfing. 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20070726/c1871854/attachment.html