The first step to working with data in a DBMS is setting up a data source connection on your machine to the DBMS. This is necessary for a DBMS installed on to your machine or on the network. SQL Server and PostGIS require an Open Database Connectivity (ODBC) connection and Oracle Spatial requires an Oracle Call Interface (OCI) connection.
You must have the ODBC driver or OCI installed on your machine before creating a data source connection. MapInfo Pro installs or updates Windows ODBC drivers if they are older than the version that MapInfo Pro supports. For non-Windows databases, such as Oracle and PostgreSQL with PostGIS, consult with your database administrator for information on how to obtain and install the driver provided with your database.
You can create a data source connection:
- Through MapInfo Pro's interface.
- Through MapInfo EasyLoader's interface, see the MapInfo EasyLoader User Guide.
- From your Microsoft Start menu: on the Start menu, click Control Panel, click Administrative Tools, and click Data Sources (ODBC).
You must set up a data source connection for each DBMS that you plan to work with.
See also: MapInfo EasyLoader