ODBC driver

You'll be presented to the ODBC download link, as well as how you can connect.


Download

Linux x86 (.deb).

Linux x86 (.rpm).

Linux x64 (.deb).

Linux x64 (.rpm).

Mac.

Windows.


Connection

To connect to ODBC Driver you can follow our Connecting to ODBC guide.

Connection Options

The ODBC driver has a lot of connection string options that you can use to customize your experience, below you can find the most important ones.

  • Logfile: The path to the log file, with the log file you can find the translations made by the driver and debug if any error occur;
  • Verbosity: The log verbosity, you can set a value between 1 and 5 where 1 is the lower verbosity and 5 the higher.
  • Auto-create: Allows to auto-create missing columns using the INSERT statement, using Other="EnforceTableSchema=false"

You can find all the connection string options on the JDBC Driver documentation.


SQL compliance

The driver supports the SQL-92 insertions and queries, so you can use pure SQL to make queries and insertions using the ODBC driver.
Learn more about SQL compliance in other pages of this section.