Each time you start MapInfo Pro, you must set the connection to your database before you can work with tables. The connection remains active while MapInfo Pro is open. The connection closes when you exit MapInfo Pro.
The following instructions are applicable to SQL Server and PostGIS users. Oracle users, see Connecting to Oracle after Re-Starting MapInfo Pro.
To open a connection to your database:
- On the HOME tab, in the File group, on the Open list, click Database Table. This can also be done on the TABLE and MAP tabs.
- If the Open DBMS Connection dialog box opens, select ODBC from the list and then click New.
- In the Select Data Source dialog box:
- Select the Machine Data Source tab.
- From the Data Source name list, select your connection name.
- Click OK.
You may see a login dialog box for your database connection. If you see this dialog, then provide the information required, such as user name and password for the database. For example, SQL Server users may see the following:
You are now ready to open a table. On the HOME tab, in the File group, on the Open list, click Table and then from the Files of type list, select your data source name from the list to display the table in your database.