ODBC Drivers for Linux/FreeBSD
This article describes the ODBC drivers provided by Exasol to connect applications running on Linux or FreeBSD with an Exasol system.
The Exasol ODBC drivers for Linux and FreeBSD are tested on the following systems:
- Linux
-
CentOS 7
-
CentOS 8 Stream
-
OpenSUSE 15
-
Debian 10
-
Ubuntu 20.04 LTS
-
Ubuntu 22.04 LTS
-
FreeBSD
-
FreeBSD 13.2
-
FreeBSD 14.0
The Exasol ODBC driver needs at least OpenSSL 1.1 to run. On some operating systems, OpenSSL must be installed separately.
Download and install the ODBC driver
-
Download the latest driver for your operating system from the Exasol Download Portal.
- Run the following commands to extract the package in a directory:
- For Linux/FreeBSD:
tar -xzf Exasol_ODBC-<version>.tar.gz
- For Solaris:
gtar -xzf Exasol_ODBC-<version>.tar.gz
- For Linux/FreeBSD:
For configuration information, see the readme.txt
file included in the driver package.
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 ODBC driver and data sources
To configure the driver, run the config_odbc
program to generate the odbc.ini
file. Change into the install directory and then run config_odbc
as shown below:
Running the config_odbc
performs the following operations:
- Scan the system for available ODBC driver manager
- Check for missing (3rd party) packages
- Create an
odbc.ini
config file - Create a wrapper script to start applications
- Test the database connectivity
- Suggest the correct DSN an application needs based on the driver manager it uses
The generated odbc.ini
file contains DSN entries for all supported ODBC
driver managers. To further configure the options in the odbc.ini
file, see Connection strings.
The config_odbc
program also allows non-interactive use. For details, run the following command:
Known Issues
Issue | Reason | Solution |
---|---|---|
config_odbc does not start |
The operating system may not have the full Perl installation. |
Install a full Perl system and try again. Fix: minimal Debian
Fix: minimal CentOS 7
|
Error "Data source name not found, and no default driver specified" |
Wrong version of the |
Specify the correct version of the |
The unixODBC driver manager is using the wrong odbc.ini file. |
Specify the correct |
|
Error "Invalid UTF-8 character in input" |
Wrong locale defined in the |
Define a locale in the |
Missing or wrong characters in output of console or your ODBC application |
Incompatible locale defined in the |
Set the environment variables Applications using the DataDirect driver manager need UTF-8 locales. |