Infrastructure Map Server General Discussion

Infrastructure Map Server General Discussion

Reply
*NermeenBakr
Message 1 of 6 (189 Views)

sql connection data resource empty(Map studio 2007)

189 Views, 5 Replies
08-08-2006 08:56 AM
Hi,
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 empty.so 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
Member
JamesLockyer
Posts: 5
Registered: ‎08-31-2006
Message 2 of 6 (189 Views)

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

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

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.

regards

Jim
Member
JamesLockyer
Posts: 5
Registered: ‎08-31-2006
Message 3 of 6 (189 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

Jim
Valued Contributor
Keith.Campbell1
Posts: 93
Registered: ‎12-10-2003
Message 4 of 6 (189 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.

Keith
Employee
dswilson
Posts: 729
Registered: ‎09-14-2006
Message 5 of 6 (189 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.

Regards,
Dave


Dave Wilson
SQA Analyst
AEC IM
Autodesk, Inc.

Active Member
juliogutierrez
Posts: 6
Registered: ‎09-26-2006
Message 6 of 6 (189 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
Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.