Configure the ODBC

This procedure describes how to configure the ODBC for a 32 or 64 bit environment.

Prerequisite: Make sure that you have a working SQL Net connection to the database when configuring ODBC.

Configure the ODBC

  1. On a 64-bit environment:
    1. Open Windows Explorer.
    2. Open the folder Windows > syswow64.
    3. Double-click the odbcad32.exe file. The ODBC Data Source Administrator window opens.

    2. On a 32-bit environment:

    1. Select Start > Settings > Control Panel.
    2. Double-click Administrative Tools.
    3. Double-click Data Sources (ODBC). The ODBC Data Source Administrator window opens.
  2. Click the System DSN tab. The System Data Sources list appears.

    3. If a database already exists, you can skip the steps 4-9. If not, proceed with step 4.

  3. Click Add.
  4. In the Create New Data Source window, select the Oracle in Ora11g driver from the list.

  5. Click Finish. The Create New Data Source window closes, and the Oracle ODBC Driver Configuration window appears.

  6. Enter the name of the database in the Data Source Name field and the name of the TNS service in the TNS Service Name field.

    7. Optionally, enter a description, which identifies the database, in the Description field.

  7. Click OK to close the window and return to the ODBC Data Source Administrator window.
  8. Click OK to close the window. The configuration of the ODBC is complete.