[mapguide-users] RE: MySQL Database Feature Source Cordiante System

[Kenneth, GEOGRAF A/S]

You cannot see the tables on the datasource. That is by design. The 
tables are considered schema's within the datasource.

You should be able to see all the tables, when you are creating the layer.

When working with databases, I would recommend not using any non-english 
charaters, even though the database supports it. Many third-party 
applications break when they encounter such characters.

Did you enter the center coordinate on the map?

Try looking at the MapGuide log files. They should be in
C:\Program Files\MapGuideOpenSource\Server\Logs

There might be a message if something went wrong.

Regards, Kenneth, GEOGRAF A/S



Dhirendra Kumar wrote:
> Hi Kenneth,
>
> As per your suggestion first i create one datasource (Connection was
> succesfull) and after that create layer with existing datasource, and also
> create map and mention cordinate system. But my problem is still same. In
> MySQL Database one table with 15 fields and i want to create Points on field
> Longitude and Latitude. Any problem in this field name ? During creation of
> datasource, not getting any option to select any specific table but when i
> use join feature then i can view all tables name for join purpose. Help
> me......
>
> Regards,
> Dhirendra Kumar
>
>
>
> Kenneth, GEOGRAF A/S wrote:
>   
>> As Dave wrote, you must zoom in to the data.
>> Since you cannot enter coordinates on the layer preview, it will not show.
>>
>> To view data you must:
>>
>> Create a datasource.
>> Create a layer with the datasource.
>> Create a map.
>> Select the coordinate system.
>> Specify the center coordinate manually.
>> Add the layer.
>> Press refresh.
>>
>> If it still won't show, doublecheck the connection on the datasource, 
>> and press the "Test connection" button.
>>
>> Regards, Kenneth, GEOGRAF A/S
>>
>>
>>
>> Dhirendra Kumar wrote:
>>     
>>> Hi Dave,
>>>
>>> You are right, not any fied in autodesk studio 2007 for mention cordinate
>>> system but when i am creating layer using data source, then why Layer is
>>> not
>>> showing in map preview window of Autodesk studio 2007. Please help me
>>> ....... Thankyou in Advance.
>>>
>>> Regards,
>>> Dhirendra Kumar
>>>
>>>
>>> Dave Wilson-3 wrote:
>>>   
>>>       
>>>> As per my previous email unless you have the new MGOS beta there is no
>>>> field to specify a coordinate system override since currently MySQL
>>>> doesn't support coordinate systems in the native schema. You can specify
>>>> the correct coordinate system in your map but you will have to zoom and
>>>> find the data to set the extent yourself.
>>>>
>>>> Regards,
>>>> 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: Monday, May 28, 2007 5:07 AM
>>>> To: mapguide-users at lists.osgeo.org
>>>> Subject: [mapguide-users] MySQL Database Feature Source Cordiante System
>>>>
>>>>
>>>> Hi All,
>>>>
>>>> I have successfully established connection of MySQL 5.0 Database and
>>>> mapguide 1.1.0 with the help of Autodesk MapGuide Studio 2007 but when
>>>> creating Layer using this data source then layer is not showing in
>>>> autodesk
>>>> Layer Preview window, I think this is happning due to cordinate system,
>>>> If i
>>>> am right then where is option of providing cordinate system of MySQL
>>>> data
>>>> source ? If i am wrong then please give me idea, How to solve this
>>>> problem ?
>>>>
>>>> Regards,
>>>> Dhirendra Kumar
>>>> -- 
>>>> View this message in context:
>>>> http://www.nabble.com/MySQL-Database-Feature-Source-Cordiante-System-tf3
>>>> 827380s16610.html#a10834515
>>>> 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
>>
>>
>>     
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20070529/6dadf7c8/attachment.html