VERIFIED SOLUTION i

How to connect to an Oracle Database in MapInfo Pro application

Product affected: MapInfo Pro™ application
Follow these steps to connect to an Oracle Database in MapInfo Pro™ application:

Before you begin, you will need the following installed on your machine:
  • Oracle Client - connects to an Oracle database.
  • TCP\IP - a communications protocol required by Oracle Client to communicate on the network
  • Oracle SQL*Net - for performing SQL queries to the database (optional).
Have your database administrator check that the:
  • tnsnames.ora file is correctly configured on your machine for the server you want to connect to.
  • Service to the database is configured-they may need to run the Net Configuration Assistant utility that Oracle provides to configure the service.
  • TCP\IP working properly (using ping.EXE).
  • Environmental variable TNS_ADMIN is correctly set to your client_1 path (the Oracle Client installation directory).
To create a new Oracle Spatial data source connection, set up your Oracle Driver:
  1. On the Start menu, click All Programs, click Oracle, click Configuration and Migration Tools, and then click Microsoft ODBC Administrator.
  2. In the ODBC Data Source Administrator, under the User DSN tab, click Add.
  3. In the Create New Data Source wizard:
  • From the driver name list, select the Oracle in OraClient driver and then click Next.
  • Click Finish to install the driver.
       4. In the ODBC Text Setup dialog box, set the following:

            Data Source Name - Provide a name for this data source. This is the name you will see after setting up this connection in the Select Data Source dialog box.

            Description - Optionally, type a description if you plan on connecting to more than one database and would like a description for this connection.
             Click OK.

To set up your Oracle Spatial connection in MapInfo Pro:
  1. 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.
  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.

                  Optionally, check the Use Operating System Authentication check box to use your Windows authentication when accessing this Oracle database.

                  Click OK.

You have an active connection to your Oracle database. You must now create a map catalog for the database
UPDATED:  November 14, 2017