VERIFIED SOLUTION i

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

Product affected: MapInfo Pro™
 

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