Advanced connection options

Devart ODBC Driver for PostgreSQL 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 PostgreSQL is configured.

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

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

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

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

Available options

Metadata section

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

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

Connection section

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.

Connection Timeout – Set the maximum time (in seconds) the driver will wait for a connection attempt before stopping. The default is 15 seconds.

IP Version – Specify the Internet Protocol version to use:

  • IPv4 – Uses Internet Protocol version 4 (IPv4).
  • IPv6 – Uses Internet Protocol version 6 (IPv6).
  • IPBoth – 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.

Protocol – Specify the PostgreSQL protocol version to use for communication with the server.

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

Use Multiple Connections – Enable this option to open parallel connections to the database.

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.

String Types – Select the string type for data exchange:

  • Default – Uses the driver’s default string type.
  • Ansi – Returns all string types as SQL_CHAR, SQL_VARCHAR, and SQL_LONGVARCHAR.
  • Unicode – Returns all string types as SQL_WCHAR, SQL_WVARCHAR, and SQL_WLONGVARCHAR.

Uuid With Braces – Enable this option to display UUIDs (Universally Unique Identifiers) in curly braces.

Enable PgGIS – Enable this option to activate support for the PostGIS extension in PostgreSQL.

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.