[mapguide-users] RE: wrong Polygon selection

[Kenneth, GEOGRAF A/S]

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: mapguide-users-bounces at lists.osgeo.org
>>>>>> [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Dhirendra
>>>>>> Kumar
>>>>>> Sent: Friday, July 20, 2007 7:04 AM
>>>>>> To: mapguide-users at 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 at lists.osgeo.org
>>>>>> 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
>>>>>>
>>>>>>
>>>>>>     
>>>>>>         
>>>>>>             
>>>>>   
>>>>>       
>>>>>           
>>>> _______________________________________________
>>>> mapguide-users mailing list
>>>> mapguide-users at 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 at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>>
>>     
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20070725/740aba13/attachment.html