Advanced connection options

Devart ODBC Driver for Oracle provides advanced connection options, allowing you to customize settings to suit your specific needs.

You can configure these custom settings when creating a new Windows DSN or modifying an existing DSN.

1. Open the ODBC Data Source Administrator.

2. Navigate to the User DSN or System DSN tab, depending on where the DSN for Oracle is configured.

3. Select the Oracle data source, then click Configure.

4. In the Devart ODBC Driver for Oracle Configuration dialog that opens, navigate to the Advanced Settings tab.

The Advanced Settings tab of the Devart ODBC Driver for Oracle Configuration window

5. Configure the required settings, then click OK to save and apply the changes.

Available options

Metadata section

All Schemas – Enable this option to use all schemas that an Oracle user has been granted privileges on.

Empty Strings as NULL – Enable this option to treat empty strings as NULL values when interacting with Oracle data.

Allow NULL Strings – Enable this option to permit NULL string values in the dataset.

Connection section

Schema – Specify the schema to be used for the session.

Character Set – Specify the character set for the driver to use when reading and writing character data.

Use Unicode – Enable this option to permit Unicode support.

IP Version – Specify the Internet Protocol version to use:

  • IPv4 – Uses Internet Protocol version 4 (IPv4).
  • IPv6 – Uses Internet Protocol version 6 (IPv6).
  • IPv4 + IPv6 – Uses either Internet Protocol version 6 (IPv6) or version 4 (IPv4). If IPv6 is enabled in the operating system, a connection is attempted via IPv6. If the connection attempt fails, a new connection attempt is made via IPv4.

Connection Timeout – Set the maximum time (in seconds) before the driver stops attempting to establish a connection. Useful for preventing hangs in unstable environments.

Ignore Command Timeout – Enable this option to ignore any attempt to change the query timeout value via the SQLSetStmtAttr and SQLSetConnectAttr functions.

Min Fetch Rows – Set the minimum number of rows for the driver to fetch from the server during query execution.

Read Only Connection – Enable this option to prevent data modification.

Compatibility section

ODBC Behavior – Select the ODBC behavior:

  • Default – Uses the default behavior of the driver.

  • Ver 2.x – Emulates ODBC 2.x behavior for compatibility with older applications.

  • Ver 3.x – Emulates ODBC 3.x behavior for compatibility with newer standards.

DATE Type – Select the DATE data type for data exchange:

  • Default – Maps Oracle DATE to ODBC SQL_TYPE_TIMESTAMP.

  • DateOnly – Maps Oracle DATE to ODBC SQL_TYPE_DATE.

String Types – Select the string type for data exchange:

  • Default – Uses the driver’s default string type.

  • Ansi – Uses ANSI encoding for string data.

  • Unicode – Uses Unicode encoding for string data.

Use Local Regional Settings when converting to string section

Numbers – Enable this option to format numbers according to the system’s local regional settings.

Dates and Times – Enable this option to format dates and times based on the system’s local regional settings.