Creating a data source connection to postgis – Pitney Bowes MapInfo Professional User Manual

Page 169

Advertising
background image

Creating a Data Source Connection to PostGIS

Before you begin, you need a PostgreSQL ANSI ODBC driver (psqlODBC) installed on your machine.
Check with your database administrator to install the driver for your database. Ensure that your database
administrator adds your machine IP address to the pg_hba.conf file for the database you want to connect
to.

You need to know the database name, server name, username and password to the database, and
whether or not you need a specific SSL Mode or Port number.

To create a new PostgreSQL PostGIS data source connection:

1. From the File menu, select Open DBMS Connection.

2. If the Open DBMS Connection dialog box displays, select ODBC from the list and then click New.

3. In the Select Data Source dialog box, select either the File Data Source or the Machine Data

Source tab and then click New.

You can share the connection information for a file data source with other users on the network if
they have the necessary drivers, because it is stored in a file. You cannot share the connection
information for a machine data source, because it is stored in the registry on the local computer.

169

MapInfo Professional User Guide

Chapter 7: Working with Data in a DBMS

Advertising