VERIFIED SOLUTION i
X

How to resolve error opening DBMS PostGIS table in MapInfo Professional 11.0

Issue

When trying to open a PostGIS 2.0.1 table with Mapinfo Professional 11.0 (or any version older than Pro 12.0) after uploading the table with Easy Loader, an error is displayed:

Error ODBC: ODBC RC=-1, ODBC SQLState=42883, DBMS RC=7, DBMS Msg=ERROR: function public.asbinary(geometry) does not exist;

Cause

MapInfo Pro 11.0 does not Support Post GIS 2.0.

Resolution

UPDATED: September 21, 2017


PostGIS 2.0 support was introduced in MiPro v. 12.0.

Also will need the correct driver installed; for PostGIS 2.0 version, the correct driver version is 09_01_0200-1.
--------------------------------------------------------------------------------------------------------------
Customer can have IT or DBA run the attached script on the server. It will add backward capability and allow MIPro v11 to work with PostGIS 2.0

Environment Details

Product affected: MapInfo Pro™
 

Downloads

  • No Downloads