ODBC Driver for Windows

This article describes the ODBC driver provided by Exasol to connect Windows applications with an Exasol system.

System requirements

  • You must have system administrator rights for the system where you are installing the driver.
  • Microsoft .NET Framework 4.6.2 must be installed on the system.
  • All applications and services that use ODBC must be stopped during installation.
  • If Business Objects XI is installed on the system, the Web Intelligence Report Server service must be stopped.

The ODBC driver for Windows is tested on the following operating systems:

Windows (64-bit)

  • Windows 10

  • Windows Server 2016

  • Windows Server 2019

  • Windows Server 2022

Windows (32-bit)

  • Windows 10

Download and Install the ODBC Driver

  1. Download the latest driver for your operating system from the Exasol Download Portal.

  2. Run the executable file and follow the setup wizard to complete the installation.

In case of an update, existing ODBC data sources are automatically configured for the new driver.

License

Each driver package includes the latest version of the license for the driver. The license allows you to bundle the driver with third-party software, for example when creating plugins for a BI tool. For more details, refer to the license file which is located in the folder where the driver was installed.

Configure Driver and Data Sources

Do the following to configure the driver and the data sources:

  1. Open the ODBC Data Source Administrator tool.
  1. Click Add in the User DSN or System DSN tabs.
  2. Select EXASolution Driver in the Create New Data Source dialog and click Finish.

    Configuring the ODBC driver and the data sources

  1. Select Connection tab in the EXASolution ODBC configuration dialog.

    Configuring the ODBC driver and the data sources

  1. Enter the following details:
  • Datasource name: Name of the new ODBC data source
  • Connection string: List of host names or IP addresses and the port of the Exasol cluster (for example, 192.168.6.11..14:8563).

    The system must be capable of resolving the host names. If it is not possible, contact your network administrator.

  • Encryption: Enables or disables the automatic encryption.
  • Username: Name of the default user for this connection.
  • Password: Password of the default user.
  • Default schema: The name of the schema that is automatically opened when the connection is established. If this schema is not available during the attempt at establishing the connection, an error message is displayed and the connection with Exasol fails.
  • Test connection: You can use this to test whether the connection data has been entered correctly. This initiates a connection with Exasol.
  1. (Optional) Click Advanced tab and define the following options and click OK:
  • SQL Prepare always successful
  • Log file
  • Log mode
  • Character locale (LC_CTYPE)
  • Numeric locale (LC_NUMERIC)
  • Query timeout
  • Show only current schema
  • Additional connection string parameters

    Configuring the ODBC driver and the data sources

The new connection appears in the list of Windows data sources.

The Connection Pooling of the driver manager is deactivated by default, you can activate it in the configuration tool "ODBC Data Source Administrator". In that case reused connections keep their session settings which were set through SQL commands (for more information, see ALTER SESSION).

Known Issues

Issue Screenshot Reason Solution
System error codes: 126, 127, 193, or 14001 Known issue 126, 127, 193, or 14001 for ODBC Driver

Important elements of the ODBC driver are not installed correctly.
  • Quit all applications and services that may be used by the ODBC driver and re-install the Exasol ODBC driver.
  • In case of error 14001, important system libraries needed by the Exasol ODBC are not installed on this machine. Re-install the Visual C++ Redistributables and then the Exasol ODBC driver.
  • Install the latest Windows updates.

Incompatible dll versions

 Known issue "Incompatible dll version" ODBC Driver

An older version of the Exasol ODBC was already installed and it was not overwritten during the installation.

Quit all applications and services that may be used by the ODBC driver and re-install the Exasol ODBC driver.

Error opening file for writing.

 Known issue "Error opening file for writing" ODBC Driver

The installer has detected that it cannot overwrite an Exasol ODBC component.

Quit all applications and services that may be used by the ODBC driver and re-install the Exasol ODBC driver.

Data source name not found and no default driver specified.

 Known issue "Data source name not found and no default driver specified" ODBC Driver

Data source name is not specified properly.
  • Check the Data Source name.
  • On a 64-bit system, check if the created data source is a 64-bit data source. Although, the application expects a 32-bit data source or vice versa.