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

[Dhirendra Kumar]

Hi Kenneth,

First i want to give you thankyou for your quick replay. Acording to you
when i go to create Layer then i can view only  Data resource used in this
layer  field and select saved Datasource name and i save this layer as a
same name of Datasource But i am not getting tables name individually and
after that i make map using this layer then i can view only Coordinate
system option and initial view option for initial Zoom setting option  But i
am not getting any option for center coordinate. For Information i am using
MGOS 1.1.0, MySQL 5.0 and Autodesk mapguide studio 2007.So please help me.

Regards,
Dhirendra Kumar


Kenneth, GEOGRAF A/S wrote:
> 
> 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
>>>
>>>
>>>     
>>
>>   
> 
> _______________________________________________
> 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/MySQL-Database-Feature-Source-Cordiante-System-tf3827380s16610.html#a10853653
Sent from the MapGuide Users mailing list archive at Nabble.com.