ODBC Driver for Oracle

Connecting to Oracle


  1. After the driver is installed, it can be configured. For this, in the Control Panel open Administrative Tools and find the Data Sources (ODBC) tool:

    Data_Sources_tool

  2. Now you have to add the ODBC Driver for Oracle to the list of System Data Sources or User Data Sources or File Data Sources using the ODBC Data Source Administrator dialog.

    added_DSN

  3. For this, click the Add button - the Create New Data Source dialog will appear with a list of available drivers.

    Select ODBC Driver for Oracle and click Finish.

    create_DSN

    Then you will be suggested to configure the driver.

  4. Two connection modes are available: using client library and Direct. Direct Mode is used for direct connection to a data source via TCP\IP avoiding client software. Some of the connection options are available in Direct Mode and not required when using client software:

    OCI Mode:

    OCI Mode

    Direct Mode:

    Direct Mode

  5. Then you can click OK and finish configuration or switch to the Advanced settings tab to specify more detailed Connection String. See the full list of supported connection string options in the Connection Options article.
© 2015-2017 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback