[mapguide-users] Solve problem MySQL Polygon Selection
Kenneth, GEOGRAF A/S
ks at geograf.dk
Fri Aug 3 03:24:35 EDT 2007
The error you describe means that some Dll required by the provider is
not present, or the wrong version.
You can try to load the OGRProvider.dll into "Dependency Walker" to see
all its Dll references.
www.dependencywalker.com
Regards, Kenneth, GEOGRAF A/S
Dhirendra Kumar skrev:
> Hi Rahul,
>
> Thankyou for your replay but i not get any mail for OGR Provider. I can
> establish connection with MGOS1.2.0 and PostGIs1.2.1 Provider but i want to
> use OGR Provider for better peroformenace but i am not getting Connection
> properties in Studio. Kenneth repalyed me to use OGR provider for better
> performance. So i want to use OGR Provider for MGOS1.2.0RC2.
>
> Regards,
> Dhirendra Kumar
>
>
> Rahul-2 wrote:
>
>> Hi,
>> I haven't got any Problem in establishing the connection using
>> MGOS 1.2.0 and PostGIS 1.2.1 for PostgreSQL 8.2,I already send you the
>> details about the connection strings and other pertinent things in my
>> previous e-mails,anyway i will send you the OGR at your e-mail so that you
>> can configure and get going.
>>
>> Cheers
>> Max !!
>>
>> Dhirendra Kumar <dhirendra.mgos at gmail.com> wrote:
>>
>> Hi Rahul-2,
>>
>> I download OGR provider ( OGRProvider-3.2.2.win32.zip ) Release binaries
>> for
>> windows from your given site. but i unable to establish connection. when i
>> unzip in server FDO directory and change in Provider.xml file and open
>> Studio 2007 and select OGR Provider then i saw nothing in Connection
>> properties ( Property and value option is blank). I repeating once again,
>> currently i use MGOS1.2.0 RC2. I also unzip this OGR provider in
>> FDO2FDO_v0_7_5 directory and when i try it then i get message unable to
>> load
>> the FDO Provider: The specified module could not be found. Rahul where i
>> am
>> wrong ? Kenneth If you are reading this message then i hope you can help
>> me
>> Couz you already establish connection between PostGIS Database and OGR
>> Provider. Please Help Me. Thankyou in Advance.
>>
>> Regards,
>> Dhirendra Kumar
>>
>>
>>
>> Rahul-2 wrote:
>>
>>> Hi,
>>> Just check this link and download the OGR Provider Release
>>> Binaries for Windows.
>>>
>>> http://fdo.osgeo.org/downloads.html
>>>
>>> I think you wrote nice about Image Tool Tip but make it more clear in
>>> order to understand about dynamic images.
>>>
>>> Cheers
>>> Max !!
>>>
>>> Dhirendra Kumar wrote:
>>>
>>> Hi Kenneth,
>>>
>>> Thankyou for your replay once again. If OGR provider have no problem in
>>> selection then i can use OGR Provider in place of PostGIS provider. I am
>>> using MGOS 1.2.0 RC2 and Autodesk MapGuide studio 2007. So, from where
>>> i'll
>>> get OGR Provider that work fine with MGOS 1.2.0 RC2. Thankyou in Advance.
>>>
>>> Regards,
>>> Dhirendra Kumar
>>>
>>>
>>>
>>> Kenneth, GEOGRAF A/S wrote:
>>>
>>>> I have no experience with the PostGIS provider.
>>>> I had no delays using OGR for PostGIS data.
>>>>
>>>> Regards Kenneth, GEOGRAF A/S
>>>>
>>>>
>>>>
>>>> Dhirendra Kumar skrev:
>>>>
>>>>> Hi Kenneth,
>>>>>
>>>>> I make layer using PostGIS provider not OGR Provider. No problems with
>>>>> tooltips, it is working fine. only problem with polygon selection
>>>>> taking
>>>>> 4
>>>>> second to highlight. OGR Provider can solve this problem ? Yes Kenneth
>>>>> before displaying layer or map server use 100% CPU and before tool tips
>>>>> displaying server use 10-20% CPU. Any way to overcome this problem ?
>>>>>
>>>>> Regards,
>>>>>
>>>>> Dhirendra kumar
>>>>>
>>>>>
>>>>> Kenneth, GEOGRAF A/S wrote:
>>>>>
>>>>>
>>>>>> I recall that there was a problem with selection/info in some version
>>>>>> of
>>>>>> the OGR.
>>>>>> What version of the OGR provider do you use?
>>>>>>
>>>>>> Does your server use 100% CPU before displaying?
>>>>>> Is the problem the same with tooltip's ?
>>>>>>
>>>>>> Regards, Kenneth, GEOGRAF A/S
>>>>>>
>>>>>>
>>>>>> Dhirendra Kumar skrev:
>>>>>>
>>>>>>
>>>>>>> Hi Kenneth,
>>>>>>>
>>>>>>> Once again i am asking qustion to you about Postgres/PostGIS, Kenneth
>>>>>>> I
>>>>>>> import table in PostGIS database using shp2pgsql tool. I can create
>>>>>>> Layers
>>>>>>> from PostGIs Database. But when i select any polygon then polygon
>>>>>>> highlight
>>>>>>> after 4 second, So can i increase performence of polygon selection ?
>>>>>>> 300
>>>>>>> polygon on current layer. I also provide index but problem is still
>>>>>>> same.
>>>>>>> Any thing wrong in my process ? Please help me.
>>>>>>>
>>>>>>> Regards,
>>>>>>> Dhirendra Kumar
>>>>>>>
>>>>>>> Kenneth, GEOGRAF A/S wrote:
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>> As someone else mentioned, the selection problem is a known bug in
>>>>>>>> the
>>>>>>>> MySQL provider.
>>>>>>>> You have the following options:
>>>>>>>> 1. Wait until someone fixes the problem.
>>>>>>>> 2. Download source and fix it yourself (or perhaps pay someone to do
>>>>>>>> it)
>>>>>>>> 3. Use another provider
>>>>>>>>
>>>>>>>> If you MUST use a "real" database, I can only suggest Oracle (you
>>>>>>>> have
>>>>>>>> tried the others).
>>>>>>>> Are there any reason that you cannot use SDF files?
>>>>>>>>
>>>>>>>> Regards, Kenneth, GEOGRAF A/S
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> Dhirendra Kumar skrev:
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>> Hi All,
>>>>>>>>>
>>>>>>>>> Sorry for repeating this qustion. I tested MS SQL server, MySQL,
>>>>>>>>> Postgresql/postGIS and i got result MySQL performance is better in
>>>>>>>>> compare
>>>>>>>>> of all, but problem in polygon selection. I want to know that, no
>>>>>>>>> way
>>>>>>>>> to
>>>>>>>>> solve this polygon selection problem ? :(
>>>>>>>>> PROBLEM:- When i select some polygon then near polygon get
>>>>>>>>> highlighted
>>>>>>>>> in
>>>>>>>>> place of current selection.
>>>>>>>>> If anyone have idea or suggestion then please help me. Thankyou in
>>>>>>>>> Advance.
>>>>>>>>>
>>>>>>>>> Regards,
>>>>>>>>>
>>>>>>>>> Dhirendra Kumar
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>> _______________________________________________
>>>>>>>> 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
>>>>
>>>>
>>>>
>>> --
>>> View this message in context:
>>> http://www.nabble.com/Solve-problem-MySQL-Polygon-Selection-tf4170008s16610.html#a11963979
>>> 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
>>>
>>>
>>>
>>> ---------------------------------
>>> Got a little couch potato?
>>> Check out fun summer activities for kids.
>>> _______________________________________________
>>> 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/Solve-problem-MySQL-Polygon-Selection-tf4170008s16610.html#a11977437
>> 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
>>
>>
>>
>> ---------------------------------
>> Ready for the edge of your seat? Check out tonight's top picks on Yahoo!
>> TV.
>> _______________________________________________
>> 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/20070803/8ad44a8b/attachment.html
More information about the mapguide-users
mailing list