MapInfo and SQL Server 2008

For a new project I am working for the first time with MapInfo 10 “the world’s premier desktop mapping application.”

In an effort to move away from MapInfo’s .tab files (the shapefile equivalent) I was keen to test out the direct connection to geometry stored in SQL Server 2008. Until version 9.5 data could only be stored and accessed in a relational database using SpatialWare. Again to use ESRI terminology this is the ArcSDE equivalent. Fortunately MapInfo was quick off the mark in removing this barrier.

Access to SQL Server 2008 spatial data is provided by integrating FME functionality directly into the product, and having a “Universal Data” option on the File menu. There is also a tool named Easy Loader that allows loading .tab files into SQL Server as geometry.

Unfortunately on trying to use the Universal Data menu after installing a fresh copy of MapInfo 10 I was met with the error “This application has failed to start because qfmeext.dll was not found. Re-installing the application may fix this problem.”

Hardly a good premier start..Anyway it appears upgrading to the 10.0.1 maintenance release fixes this issue. No mention of the issue itself in the release notes (Update: It is in the release notes, see comments below, and only occurs when ArcGIS is also installed). There were also a couple of additional fixes for SQL Server (fhe following text direct from the maintenance release notes).

Improving Performance when Connecting to a SQL Server Database

To improve performance when accessing large SQL Server tables, add a Multiple Active Result Sets (MARS) connection setting to the connection string in the live access .TAB file. The connection attribute to update is \DATALINK\ConnectionString, for example:

"\DATALINK\ConnectionString" = "DSN=local-native10;UID=username;
Trusted_Connection=Yes;APP=MapInfo Professional®;
WSID=hostname;DATABASE=test;MARS_Connection=Yes;"

You may also add the MARS connection setting to the connection string of MapBasic Server_Connect( ) command. Note that a MARS connection:

  • does not work for SpatialWare tables.
  • only applies to SQL Native Client or SQL Server Native Client 10. Other connection types so not benefit from this setting.

Also Fixed..

T25293 Opening a SQL Server table containing a column with type NCHAR causes an error message, “Unsupported data type for column…”
Resolution: Issue is resolved.



3 views shared on this article. Join in...

  1. Hi,

    Glad that you were able to get the fixes for the issues encountered. One quick comment about the error and it fixe in MI Pro 10.0.1 maintenance release. In the release notes, while one can argue that the description might not be very explicit on the error and its message, here is the reference to the issue (in the release notes):


    C15797 When ArcGIS® 9.2 or 9.3 is installed on the machine MapInfo Professional closes unexpectedly when
    opening a Universal Data File.
    Resolution: Issue is resolved.

  2. geographika says:

    @Noureddine Farah
    Thanks for taking the time to read the post and reply. Just looked through the release notes, and the issue is right at the top of the list.
    There’s nothing on Google about the error (until this post!), so it was hard to narrow down the issue.
    The SQL Server data seems to be working perfectly so far (including editing), and its nice to see MapInfo take an interest in their users.

  3. Superb do the job! Be the type of facts that ought to be embraced on the internet. Waste on the seek motors with no lengthier setting this particular article better! Occur around as well as visit my site. Thanks Equals)

Leave a Reply

Your email address will not be published. Required fields are marked *

Comment

You may use these tags : <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>