• Industries
  • Products
  • Buy
  • Services & Support
  • Communities
  • Discussion Groups

    Autodesk MapGuide Enterprise

    Reply
    Contributor
    Posts: 16
    Registered: ‎05-08-2006

    Creating connection in Studio 2012 to SQL database

    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?

    Please use plain text.
    Mentor
    Posts: 245
    Registered: ‎10-10-2003

    Re: Creating connection in Studio 2012 to SQL database

    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
    Please use plain text.
    Contributor
    Posts: 16
    Registered: ‎05-08-2006

    Re: Creating connection in Studio 2012 to SQL database

    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.

    Please use plain text.
    Mentor
    Posts: 245
    Registered: ‎10-10-2003

    Re: Creating connection in Studio 2012 to SQL database

    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
    Please use plain text.