I don't think the OGR provider has MySQL support built in.
Perhaps Traian can tell?
It does have Postgres/PostGIS support though.
You should not fill in the username/password fields, as they are not used.
You have given different passwords for the connction string / password
field.
Regards, Kenneth, GEOGRAF A/S
Dhirendra Kumar skrev:
Hi Kenneth,
Thankyou for your replay now i can see both field Datasource and Readonly,.
in Datasource field i enter MYSQL:dhiru,user=root,password=psv9570,port=3306
in Readonly field enter false and in User name: enter root and in Password:
root But when i clicked on Test CtionButton then i get Error!! An exception
occurred in FDO component.
Connect failed.So kenneth, If you have idea about this error that where i am
wrong then please help me.
Regards,
Dhirendra Kumar
Kenneth, GEOGRAF A/S wrote:
That can happen for a number of reasons.
Did you select the right version?
MGE: FDO 3.0
MGOS 1.1: FDO 3.2
MGOS 1.2: FDO 3.2.2
Regards, Kenneth, GEOGRAF A/S
Dhirendra Kumar skrev:
Hi Kenneth,
As per your suggestion, i download OGR provider and keep their dll file
in
server FDO directory and change in provider.xml. After selecting OGR
provider i got OGR Connection screen but from where i connect it with
MySQL
Database. nothing in Connection properties. Please help me. Thankyou in
advance.
Regards,
Dhirendra Kumar
Kenneth, GEOGRAF A/S wrote:
Hi Dihendra.
My experience dictates that pure SDF datasources are generally best.
If you must use MySQL, you can try to build a custom OGR provider with
MySQL support.
Alternatively, the OGR provider supports Postgres/PostGIS directly.
Regards, Kenneth, GEOGRAF A/S
Dhirendra Kumar skrev:
Hi Dave,
Please replay me, i am waiting for your suggestion. I want to know
that,
no
way to solve wrong polygon selection problem ? if not then which
Database
will be better for MGOS. please help me Co'us my project get stuck due
to
this problem. Please help me. Thankyou in Advance.
Regards,
Dhirendra Kumar
Dave Wilson-3 wrote:
This is a known issue with MySQL. MySQL only supports envelope
operations so depending on the shape of the polygons selecting one
whose
border is somewhat diagonal to another may select the wrong polygon.
Dave
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dhirendra
Kumar
Sent: Friday, July 20, 2007 7:04 AM
To: mapguide-users@lists.osgeo.org
Subject: [mapguide-users] wrong Polygon selection
Hi All,
I create polygon layer using FDO datasource from MySQL Database, In
this
layer many polygon, But problem in some polygon when i click on some
polygon
then another polygon get selected in place of current polygon. Any one
have
idea about this type of problem, Please help me......... Thankyou in
Advance.
Regards,
Dhirendra Kumar
--
View this message in context:
http://www.nabble.com/wrong-Polygon-selection-tf4116919s16610.html#a1170
7763
Sent from the MapGuide Users mailing list archive at Nabble.com.
_______________________________________________
mapguide-users mailing list
mapguide-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users
_______________________________________________
mapguide-users mailing list
mapguide-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users
_______________________________________________
mapguide-users mailing list
mapguide-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users
http://www.nabble.com/file/p11761382/ogr.jpeg
_______________________________________________
mapguide-users mailing list
mapguide-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users
_______________________________________________
mapguide-users mailing list
mapguide-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users
