[mapguide-users] RE: OGR and MGOS
Dave Wilson
dave.wilson at autodesk.com
Thu Jul 26 10:10:58 EDT 2007
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: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] 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 <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
<http://us.rd.yahoo.com/evt=48225/*http:/new.toolbar.yahoo.com/toolbar/f
eatures/mail/index.php> wherever you're surfing.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20070726/e2538f69/attachment.html
More information about the mapguide-users
mailing list