MapInfo Pro Database Connectivity and Support - 2023

MapInfo Pro Release Notes

Product type
Software
Portfolio
Locate
Product family
MapInfo
Product
MapInfo > MapInfo Pro
MapInfo > MapInfo EasyLoader
MapInfo > License Server Utility
MapInfo > MapBasic
MapInfo > MapInfo Pro Advanced
Version
2023
Language
English
Product name
MapInfo Pro
Title
MapInfo Pro Release Notes
First publish date
1985
ft:lastEdition
2023-09-12
ft:lastPublication
2023-09-12T16:43:38.341845

MapInfo Pro supports the following spatial database servers:

  • Microsoft SQL Server 2019
  • Microsoft SQL Server 2017
  • Microsoft SQL Server 2016 SP1 (also called SQL Server Spatial)
  • PostGIS 3.1 using PostgresSQL 13.2
  • PostGIS 2.5 using PostGreSQL 10.1
  • PostGIS client is 13.01 x64
  • SQLite v3.8 / FDO 3.8
  • Oracle 21c
  • Oracle 19c msp19c
  • Oracle 18c msp18c
  • Oracle Spatial 12C r2 msp12cr2
  • Oracle11gr2

In order for MapInfo Pro to access a remote database, you must install a client or driver. The following are ODBC drivers that MapInfo Pro supports:

  • Microsoft Access ODBC (64-bit)
  • Microsoft SQL Server 2019
  • Microsoft SQL Server 2017
  • Microsoft SQL Server 2016
  • Microsoft SQL Server 2012 QFE Native Client v11 (64-bit)
  • PostgreSQL Unicode and ANSI ODBC driver 13.01 (64 bit)
  • FDO toolkit 3.8 (used by SQLite and installed with MapInfo Pro)
  • Oracle Instant Client 19.11 (64-bit)
  • Microsoft ODBC Driver for SQL Server 17.8

You can also open tables of data from the following and make them mappable, but only for point data:

  • Microsoft Access 2013, 2016, and 2019 (64-bit)

For more about working with remote database information, see Accessing Remote Data and Setting your Database Connection Preferences in the Help System.

PostgreSQL ODBC Driver Requires the Use Declare/Fetch Option

To avoid an error when using the PostgreSQL Unicode ODBC driver, you must enable the Use Declare/Fetch option. When enabled, the driver automatically uses declare cursor/fetch to handle SELECT statements and keeps 100 rows in a cache. When disabled, which is the default setting, the driver buffers the entire result set. For large tables this could use all the Windows memory resources. For details, see the MapInfo Pro Install Guide.