MapInfo Pro Developers User Group

Welcome to the MapInfo Pro Developers community!  We are a group dedicated to the discussion and understanding of MapBasic and .Net MapInfoPro AddIn development. Bring your questions and ideas here. This group includes several members of the Pro development team from around the world.

Please feel free to start a discussion in the discussion tab or join in a conversation.

Product Information  Ideas Portal  MapInfo Community Downloads

Discussions

Members

Resources

Events

 View Only

  • 1.  Problem with SQL ODBC connection stability.

    Posted 03-02-2018 01:35

    I have a requirement to connect to a SQL 2008 R2 server. I generally have no trouble or rather if I do it's pretty straight forward to fix. not so this case.

     

    I ran through the normal process in V16 connecting an ODBC server and database. I used SQL credentials and TEST connection OK.

    I changed the default database to the desired target.

    I'm presented with a table selection dialog.

    I changed the option from Live to Linked. Select a table and the table opens.

    All as expected.

    However after closing Mapinfo and re-opening the existing configured ODBC connection Mapinfo will not connect to the database.

    See Attachment

    See Attachment

    I have triple checked my process and credentials and this is consistent.

    I also tried opening the linked table and attempting a Server Refresh. this follows the identical pattern described above.

    It's as though the initial connection process is setting a state that is lost when attempting to use the connection from a "cold" start.

    I tested the same connection with an old MI 8.5 license and it's fine. Performs precisely as expected.

    Any thoughts?



  • 2.  RE: Problem with SQL ODBC connection stability.

    Posted 03-01-2018 20:49

    Apologies. False alarm. I didn't realise this install wasn't patched. 16.0.3 patch addresses this issue.