What's the InterBase ODBC driver's ODBC compliance level

The InterBase ODBC driver is an ODBC 3.5 driver, and uses the ODBC Driver Manager to provide ODBC 2 functions. The InterBase ODBC driver reports its ODBC conformance level with SQLGetInfo, but in summary, the driver conforms to:

  • All the core level requirements
  • 104 and 109 of Level 1
  • 202, 205, 209 and 211 of Level 2 interface conformance

The InterBase ODBC driver implements all ODBC 3 functions with the exception of:

The InterBase ODBC driver only supports FORWARD_ONLY cursors, as this is the only type supported by InterBase. This means it will work with Microsoft ActiveX Data Objects (ADO) snapshots, but not dynasets.