<div>Hi,</div> <div> I haven't checked OGR 3.2.2 for MySQL Connection as you already have FDO Provider for MySQL-<FONT size=2>MySQLProvider.dll </FONT>,regrading the OGR 3.2.2 for the PostGIS database works Cool on the MGOS 1.2.0.</div> <div> </div> <div>I think you can try PostGIS Database with the below connection string --</div> <div> </div> <div>DataSource -----PG: host=xxxx port=xxxx dbname=xxxx user= xxx password=xxx<BR>ReadOnly--------FALSE</div> <div> </div> <div>Edit in the providers.xml file--</div> <div> </div><FONT size=2> <div><FeatureProvider></div> <div><Name>OSGeo.OGR.3.2</Name></div> <div><DisplayName>OSGeo FDO Provider for OGR</DisplayName></div> <div><Description>Access to OGR Data Sources</Description></div> <div><IsManaged>False</IsManaged></div> <div><Version>3.2.2.0</Version></div>
<div><FeatureDataObjectsVersion>3.2.2.0</FeatureDataObjectsVersion></div> <div><LibraryPath>F:\Program Files\MapGuideOpenSource\Server\Bin\FDO\OGRProvider.dll</LibraryPath></div> <div></FeatureProvider></div> <div> </div> <div>Cheers</div> <div>Max !!</div></FONT> <div><BR><B><I>Dhirendra Kumar <dhirendra.mgos@gmail.com></I></B> wrote:</div> <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid"><BR>Hi Rahul-2,<BR><BR>Are you sure that OGR 3.2 and MGOS 1.2.0 will work fine and provide<BR>connectivity with MySQL ? But MGOS 1.2.0 come with FDO 3.2.2.0 and OGR<BR>provider also available in version OGR 3.2.2, So for MySQL connectivity i'll<BR>have to reinstall FDO 3.2 with MGOS .1.2.0 ?. If you have any suggestion<BR>then please replay me. I can establish connection MGOS 1.1.0 with MySQL<BR>using default MySQL Provider but problem in Layer polygon selection, when i<BR>select one
polygon then another near polygon get highlighted and for this<BR>resion my project get stuck. So i am searching another FDO provider like<BR>postGIS or any good database that solve my problem. If you have any idea or<BR>suggestion then help me. Thankyou in Advance.<BR><BR>Regards,<BR><BR>Dhirendra kumar<BR><BR>Rahul-2 wrote:<BR>> <BR>> Hi ,<BR>> I think you check your connection string ,it should be--<BR>> <BR>> POSTGIS<BR>> DataSource -----PG: host=xxxx port=xxxx dbname=xxxx user= xxx<BR>> password=xxx<BR>> ReadOnly--------FALSE<BR>> <BR>> same kind of setting you can try for the MySQL.<BR>> <BR>> DataSource -----PG:dbname=xxxx,user=<BR>> xxx,password=xxx,host=xxxx,port=xxxx<BR>> ReadOnly--------FALSE<BR>> <BR>> I think OGR 3.2 doesn't work properly with MGOS 1.1 so try MGOS 1.2.0<BR>> with FDO 3.2.0.<BR>> <BR>> Cheers<BR>> Max !!<BR>> <BR>> nicholda <NICHOLDA@TALGOV.COM>wrote:<BR>> <BR>> I have not
tried this with MySql. The problems that was experiencing were<BR>> with PostGis. I resolved it by trying the different OGR's available. I<BR>> have<BR>> attached the one that I am currently using for PostGis. I hope this helps. <BR>> Below is also the modifications that need to be made to the Providers.xml.<BR>> <BR>> David<BR>> <BR>> <BR>> OSGeo.OGRProvider.3.2 <BR>> FDO Provider for OGR <BR>> Access to OGR data sources <BR>> False <BR>> 3.2.0.0 <BR>> 3.2.0.0 <BR>> <BR>> C:\Program<BR>> Files\MapGuideOpenSource\Server\Bin\FDO\OGRProvider.dll <BR>> <BR>> <BR>> <BR>> <BR>> <BR>> Dhirendra Kumar wrote:<BR>>> <BR>>> Hi Nicholda,<BR>>> <BR>>> I am also using MGOS 1.1 and Mapguide Studio 07, and OGR 3.2 and i can<BR>>> see<BR>>> Datasource and Readonly property, but i can't establish connection with<BR>>> MySQL Database. you have any idea about this then help me pls.
i enter in<BR>>> connection string in datasource is<BR>>> MYSQL:westholland,user=root,password=psv9570,port=3306, but it is not<BR>>> working. help me.<BR>>> <BR>>> Regards, <BR>>> Dhirendra Kumar<BR>>> <BR>>> <BR>>> nicholda wrote:<BR>>>> <BR>>>> I am also using MGOS 1.1 and Mapguide Studio 07 6.5. I get a successful<BR>>>> connection, but when I try to create a new layer from Postgres. I get<BR>>>> the attached error message.<BR>>>> <BR>>>> <BR>>>> <BR>>>> Traian Stanev wrote:<BR>>>>> <BR>>>>> I've seen that happen with some builds of the provider -- Studio does<BR>>>>> not display the connection properties. What version of MapGuide are you<BR>>>>> using?<BR>>>>> <BR>>>>> <BR>>>>> -----Original Message-----<BR>>>>> From:
mapguide-users-bounces@lists.osgeo.org<BR>>>>> [mailto:mapguide-users-bounces@lists.osgeo.org] On Behalf Of Rahul<BR>>>>> Sent: Wednesday, May 16, 2007 3:05 AM<BR>>>>> To: MapGuide Users Mail List<BR>>>>> Subject: RE: [mapguide-users] OGR and MGOS<BR>>>>> <BR>>>>> _______________________________________________<BR>>>>> mapguide-users mailing list<BR>>>>> mapguide-users@lists.osgeo.org<BR>>>>> http://lists.osgeo.org/mailman/listinfo/mapguide-users<BR>>>>> http://lists.osgeo.org/mailman/listinfo/mapguide-users <BR>>>>> <BR>>>>> <BR>>>>> _______________________________________________<BR>>>>> mapguide-users mailing list<BR>>>>> mapguide-users@lists.osgeo.org<BR>>>>> http://lists.osgeo.org/mailman/listinfo/mapguide-users<BR>>>>>
http://lists.osgeo.org/mailman/listinfo/mapguide-users <BR>>>>> <BR>>>>> <BR>>>> http://www.nabble.com/file/p10663767/Error.JPG <BR>>>> <BR>>> <BR>>> <BR>> http://www.nabble.com/file/p11781363/OGRProvider.dll OGRProvider.dll <BR>> -- <BR>> View this message in context:<BR>> http://www.nabble.com/OGR-and-MGOS-tf3728865s16610.html#a11781363<BR>> Sent from the MapGuide Users mailing list archive at Nabble.com.<BR>> <BR>> _______________________________________________<BR>> mapguide-users mailing list<BR>> mapguide-users@lists.osgeo.org<BR>> http://lists.osgeo.org/mailman/listinfo/mapguide-users<BR>> <BR>> <BR>> <BR>> ---------------------------------<BR>> Be a better Heartthrob. Get better relationship answers from someone who<BR>> knows.<BR>> Yahoo! Answers - Check it out. <BR>> _______________________________________________<BR>> mapguide-users mailing list<BR>>
mapguide-users@lists.osgeo.org<BR>> http://lists.osgeo.org/mailman/listinfo/mapguide-users<BR>> <BR>> <BR><BR>-- <BR>View this message in context: http://www.nabble.com/OGR-and-MGOS-tf3728865s16610.html#a11805486<BR>Sent from the MapGuide Users mailing list archive at Nabble.com.<BR><BR>_______________________________________________<BR>mapguide-users mailing list<BR>mapguide-users@lists.osgeo.org<BR>http://lists.osgeo.org/mailman/listinfo/mapguide-users<BR></BLOCKQUOTE><BR><p> 
<hr size=1>Get the Yahoo! toolbar and <a href="http://us.rd.yahoo.com/evt=48225/*http://new.toolbar.yahoo.com/toolbar/features/mail/index.php">be alerted to new email </a>wherever you're surfing.