Autodesk MapGuide Enterprise
Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic to the Top
- Bookmark
- Subscribe
- Printer Friendly Page
Creating connection in Studio 2012 to SQL database
Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
277 Views, 3 Replies
04-11-2012 01:54 PM
We are able to setup a connection to our database. Where the problem is, is the field selected in the primary table and the field from the SDF are the same, but when we go to view the data joined we see the fileds from the SDF and only the field names from the table. Thedata does not populate the jioned fields.
Any suggestions?
Re: Creating connection in Studio 2012 to SQL database
Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
05-09-2012 06:12 PM in reply to:
ktamm
i would make sure the column in the sdf is the exact type in sql sever, for example both INT
Re: Creating connection in Studio 2012 to SQL database
Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
05-10-2012 04:58 AM in reply to:
ktamm
Thank you for the suggestion. Yes, we have made sure that this is the case for all fields.
Re: Creating connection in Studio 2012 to SQL database
Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
05-10-2012 05:24 AM in reply to:
ktamm
i would recommend storing the spatial data in SQL server rather than SDF, then you can join in a view

