Infrastructure Map Server General

Message 1 of 6 (175 Views)

sql connection data resource empty(Map studio 2007)

175 Views, 5 Replies
08-08-2006 08:56 AM
I have a sql data base having a table which columns is(CityName,cityID,x,y)
i made a data resource through this table by adding new layer to the
mapGuide studio and set it resources to that table in that resource.The
Geometry box is empty any other thing in the setting form is dimed also the
style pannel is i cann't set styles or themes or do any thing to
the layer so as well cann't preview the layer on the map
(This layer is representing a point layer with a oledb data source in
mapGuide 6.5 and it is working fine)
am i doing something wroong?Please help.

Thanks in advance
Posts: 5
Registered: ‎08-31-2006
Message 2 of 6 (175 Views)

Re: sql connection data resource empty(Map studio 2007)

08-31-2006 02:22 AM in reply to: *NermeenBakr

Glad I'm not the only one struggling with this. My understanding is that the SQL column has to be an XML column - which presumably stores the geometry in a GML format. However in order for it to Mapguide to be able to see the geometry column you need to attach an xml schema to your xml column on the SQL server.

Currently the above is guess work.

If you get anywhere let me know.


Posts: 5
Registered: ‎08-31-2006
Message 3 of 6 (175 Views)

Re: sql connection data resource empty(Map studio 2007)

09-08-2006 06:07 AM in reply to: *NermeenBakr
Done it!

Its not about XML schemas, the reference was to database schemas.

It works by installing a series of tables onto your SQL DB prefixed with an f_ (I have a series of SQL install scripts for these). The tables store key information about the database you wish to use in Mapguide. Unfortunately I don't have a script yet to populate the tables when you create a new database. My way round this was to get a trial version of Map 3D 2007 - which running on an XP machine I managed to get it to create the FDO database and tables.

Hope this helps

Valued Contributor
Posts: 93
Registered: ‎12-10-2003
Message 4 of 6 (175 Views)

Re: sql connection data resource empty(Map studio 2007)

09-13-2006 01:11 AM in reply to: *NermeenBakr
Is there any Autodesk documentation on this? I'm struggling with this also.

Posts: 727
Registered: ‎09-14-2006
Message 5 of 6 (175 Views)

Re: sql connection data resource empty(Map studio 2007)

09-14-2006 07:32 AM in reply to: *NermeenBakr
It appears you simply require an ODBC Connection to the data. In the interface for defining the connection you must indicate a Key column (cityID) and which columns are your geometry columns (x,y). You must also specify the coordinate system the coordinates are in. Unlike MG6.5 the coordinates are not restricted to Lat/Long. Note if you use a DSN then this must be set up on the MapGuide Server machine.


Dave Wilson
SQA Analyst
Autodesk, Inc.

Active Member
Posts: 6
Registered: ‎09-26-2006
Message 6 of 6 (175 Views)

Re: sql connection data resource empty(Map studio 2007)

09-26-2006 06:29 AM in reply to: *NermeenBakr
Hello, some has idea of like debit side to be that outline XML

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Welcome to the new Autodesk Community!
If this is your first visit, click here to get started and make the most of the Community. Let us know what you think of the new experience in the Community Feedback Forum.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community