InterBase ODBC driver

ODBC driver for InterBase 6–2022

The Easysoft InterBase ODBC driver lets any application that supports ODBC access InterBase from Linux, Windows, and Solaris platforms.

The InterBase ODBC driver is compatible with the Microsoft ODBC Driver Manager and unixODBC, the open source ODBC Driver Manager, which is included with the distribution on non-Windows platforms. The InterBase ODBC driver installation can automatically install the driver into unixODBC, making the InterBase ODBC driver immediately available to your applications. The unixODBC project is currently led by Easysoft developer Nick Gorham and we have many years of experience in supporting and testing our drivers with unixODBC.

In addition, the InterBase ODBC driver:

  • Conforms to the ODBC 3.5 specification and so provides the expected functionality for ODBC 3 applications such as ADO. The InterBase ODBC driver will also work with older ODBC applications.
  • Provides direct access to all the InterBase catalog tables. This information is also available with standard ODBC calls such as SQLTables and SQLColumns.
  • Supports InterBase roles. You can specify a role either as part of the data source setup details or as an option to SQLDriverConnect.
  • Provides both ANSI and Unicode access to InterBase databases, converting from the internal UTF-8 storage format used by the InterBase server. Default character sets may be configured and all conversions are done transparently and automatically. ANSI only applications such as Microsoft Query will only "see" 8-bit ANSI data, while Unicode applications such as Microsoft Access get provided with direct access to 16-bit Unicode data.
  • Maps ODBC transaction requirements to the provided InterBase model transparently and efficiently. There is also provision to choose between "wait" and "no wait" behaviour on detection of lock conflicts.
  • Fully supports InterBase stored procedures and provides mapping from the ODBC call methods to the native InterBase calls. Provision is made for both the SELECT and EXEC PROCEDURE calling methods and the driver will pick the correct translation. A manual override on this selection is provided for unusual procedures.

Diagram

Platforms

The InterBase ODBC driver is currently available on these platforms:

Version Platform Distribution
v4.9 (Interbase 6 - 7, 2009, XE, XE3, XE7,2017,2020) Linux (x86) (32 - Bit) (kernel 2.2-4.0+, glibc 2.1+)
v4.9 (Interbase 6 - 7, 2009, XE, XE3, XE7,2017,2020) Linux (x86) (64 - Bit) (kernel 2.6-4.0+, glibc 2.3.5+)
v4.9 (Interbase 6 - 7, 2009, XE, XE3, XE7,2017,2020) Windows (x86) (32 - Bit, 64 - Bit) (7, 8, 2012 R2, 10, 2016, 2019,11,2022)
v4.3 (Interbase 6 - 7, 2009 (Unicode)) Solaris (Sparc) (32 - Bit) (2.6-2.10)