[mapguide-users] RE: RE: MySQL Database Feature Source
CordianteSystem
Dhirendra Kumar
dhirendra.mgos at gmail.com
Thu May 31 02:59:42 EDT 2007
Hi Dave,
Thankyou for your quick replay and valuable suggestion. Now i can Make
layers and view also. Thankyou once again.
Regards,
Dhirendra Kumar
Dave Wilson-3 wrote:
>
> I reread the email chain and noticed you talked about Points and
> Longitude and Latitude columns. If that is the case you shouldn't use
> the MySQL provider, but instead use an ODBC connection. You will need to
> install the MySQL ODBC Connector on your server system (it's the ODBC
> driver for MySQL).
>
>
>
> You likely don't have any geometry because there are no geometry type
> columns in your data.
>
>
>
> Regards,
>
> Dave
>
>
>
> From: mapguide-users-bounces at lists.osgeo.org
> [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Kenneth,
> GEOGRAF A/S
> Sent: Wednesday, May 30, 2007 8:11 AM
> To: MapGuide Users Mail List
> Subject: Re: [mapguide-users] RE: MySQL Database Feature Source
> CordianteSystem
>
>
>
> I think you have a problem with the database schema then.
>
> I don't think there is any live support, as this is an open source
> project.
>
> If you want real support, consider purchasing MapGuide Enterprise from
> Autodesk.
> Its basically the same product, but you get access to Autodesk support.
>
>
>
>
>
> Regards, Kenneth, GEOGRAF A/S
>
>
>
>
> Dhirendra Kumar wrote:
>
> Hi Kenneth,
>
> I am waiting for your replay. Please read my previous message for
> detail.
>
> Regards,
> Dhirendra Kumar
>
>
> Dhirendra Kumar wrote:
>
>
>
> Hi Kenneth,
>
> As per your suggestion i can view all tables during layer
> creation but
> after selection of table lower Geometry combo box is empty not
> any data in
> this combo box. Then how will i select "Geometry".In my process
> any thing
> wrong ?. Kenneth i want to live chat with any MGOS Expert, Is it
> possible
> ?
>
> Regards,
>
> Dhirendra Kumar
>
>
> Kenneth, GEOGRAF A/S wrote:
>
>
> Oh, my fault. It takes the two coorner coordinates, not
> a center
> coordinate.
>
> You must enter correct coordinates in the "lower left"
> and "upper right"
> boxes.
> You must also select the correct coordinate system.
>
> When you create a new layer, you must select a
> datasource.
> After selecting the data source, the names of the tables
> in the
> datasource should display in the combo box "Feature
> class".
> You can select the desired table here.
> You can select the column containing the geometry in the
> combobox
> "Geometry".
>
> Regards, Kenneth, GEOGRAF A/S
>
>
>
> Dhirendra Kumar wrote:
>
>
> 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
>
>
>
>
>
>
>
>
> _______________________________________________
> 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#a10888456
Sent from the MapGuide Users mailing list archive at Nabble.com.
More information about the mapguide-users
mailing list