Oracle ODBC Setup

Owned by Aryn Wiebe
Sept 03, 2024
3 min read

How to set up a new ODBC data source for Oracle on Windows:

The Oracle ODBC package depends on the OCI drivers — so you need to set them up first. Follow the procedure in: Oracle OCI Driver Setup.

  1. Install the latest Oracle ODBC drivers zip package from the Oracle instant client download site.

    1. Choose the latest Development and Runtime – optional packages > ODBC Package

    2. Unzip the ODBC zip packageinto the instantclient_X_Y folder the OCI drivers are installed. The ODBC driver files should be added to the existing OCI driver files.

    3. Open a command prompt as administrator and run the following commands to install ODBC:

      cd <directory with instantclient_X_Y> odbc_install.exe

Iguana may not always support the very latest version of the ODBC drivers, so you can simply download an earlier version if necessary.

If you need to know which versions supported by the version of Iguana you are using please contact us at support@interfaceware.com.

  1. On your Windows machine, search “ODBC” to find ODBC Data Sources (64 bit). Right Click and choose Run as Administrator to open the ODBC Data Source Administrator.

  1. Open the System DSN tab and click Add.

  1. Choose the latest Oracle ODBC driver and click Finish.

  1. Enter the ODBC credentials:

    • Use any Data Source Name and Description you prefer.

    • Enter the Oracle service name in TNS Service Name.

    • Enter the user login in the User ID field.

    • Optional: Choose your default Database.

Test the data source connection:

  1. Click Test Connection. Enter your password and click OK.

  2. If successful, click OK to create the ODBC data source.

If unsuccessful, speak to your DBA (database administrator) about changing these if necessary. There are a few settings that you may need to change:

  1. Integrated Security (default): Sometimes you might want to use a SQL Server user and password instead of the default Integrated Security to connect to a Microsoft SQL Server database. To change to a user login, select SQL Server Authentication, enter User and Password.

  2. Database: You can specify the database that you want to use by default.

  3. Incorrect port number: SQL Server defaults to port 1433, but a different port can be used. Speak to your database administrator (DBA) or network administrator.