MGOS 1.2.0 and the MySQL provider requires you have a MySQL 5.0.22 database which means if you have an earlier version you have to export all your tables and re-import them into a new install. You can then take the libmysql.dll from that new install and place it in your FDO directory.
I'm not sure this has been pointed out yet. Dave From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rahul Sent: Thursday, July 26, 2007 4:51 AM To: MapGuide Users Mail List Subject: Re: [mapguide-users] RE: OGR and MGOS 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] >>>> [mailto:[EMAIL PROTECTED] 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 >>>> [email protected] >>>> http://lists.osgeo.org/mailman/listinfo/mapguide-users >>>> http://lists.osgeo.org/mailman/listinfo/mapguide-users >>>> >>>> >>>> _______________________________________________ >>>> mapguide-users mailing list >>>> [email protected] >>>> 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 > [email protected] > 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 > [email protected] > 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 [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users _____ Get the Yahoo! toolbar and be alerted to new email <http://us.rd.yahoo.com/evt=48225/*http:/new.toolbar.yahoo.com/toolbar/f eatures/mail/index.php> wherever you're surfing.
_______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
