Connecting to Oracle after Re-Starting MapInfo Pro - MapInfo_Pro - 2023

To open a connection to your Oracle database:

1. On the HOME tab, in the File group, click Open, and Database Table.
2. In the Open DBMS Connection dialog box, select Oracle Spatial from the list and then click New.
3. In the MapInfo Oracle Connect dialog box enter the following information:
   • User Name - The username for accessing the database.
   • Password - The password for accessing the database.
   • Server Name - The name of the Oracle database that you want to connect to.

     Click OK.

You are now ready to open a table. To do this, on the HOME tab, in the File group, click Open, and Table. In the Open dialog box, from the Files of type list, select Oracle to display the table in your Oracle database.

Connecting to Oracle and Opening a Table at the Same Time

To open a connection to your Oracle database and then open a table in the database:

1. On the HOME tab, in the File group, click Open, and Table.
2. In the Open dialog box, select the Open DBMS Connection button.
3. In the Open DBMS Connection dialog box, select Oracle Spatial from the list and then click New.
4. In the MapInfo Oracle Connect dialog box:
   • User Name - The username for accessing the database.
   • Password - The password for accessing the database.
   • Server Name - The name of the Oracle database that you want to connect to.

     Click OK.

5. In the Open dialog box schema and tables in your Oracle database display. If you do not see this, then from the Files of type list, select Oracle or your data source name.
6. Select the table to open from the list and click Open.

You are now ready to work with your Oracle table.