Release notes for ODBC Driver for SQLite

Version 5.0

  • Added a graphical interface for configuring the driver on macOS and Linux.
  • Added support for the ISO 8601–like time format.
  • Improved compatibility with Node.js.
  • Improved compatibility with Tableau.
  • Improved compatibility with Vectorworks.

Version 4.5

  • Fixed the connection timeout setting before opening a connection.
  • Now keys are stored in an encrypted form in the DSN record.
  • Added the RealAsDouble connection option.
  • Improved compatibility with MS Access.
  • Improved compatibility with FileMaker Server for Linux and macOS.

Version 4.4

  • The Direct mode is now based on version 3.42.0 of the SQLite engine.

Version 4.3

  • Added support for the SQL_ATTR_MAX_ROWS attribute.
  • Improved compatibility with Visual Basic in Visual Studio.
  • Added support for macOS 13 Ventura.
  • The Direct mode is now based on version 3.39.2 of the SQLite engine.
  • Improved compatibility with Tableau Prep Builder.
  • Improved compatibility with Crystal Reports.
  • Improved compatibility with 4D in macOS.

Version 4.2

  • Added support for Windows 11.
  • Improved compatibility with FICO Mosel.
  • Improved compatibility with FileMaker.
  • Improved compatibility with JMP on macOS.
  • Improved support for the ODBC installer on Windows 2000.
  • The Direct mode is now based on version 3.31 of the SQLite engine.

Version 4.1

  • Added the MSI installer for deploying through GPO.

Version 4.0

  • Added support for Apple Silicon M1.
  • Improved compatibility with macOS Big Sur.
  • Added the JournalMode = jmDefault option.

Version 3.2

  • Added the Connect Mode connection option.
  • Added the Journal Mode connection option.
  • Added the Locking Mode connection option.
  • Added the Synchronous connection option.

Version 3.1

  • The ODBC driver is now thread-safe.
  • The Direct mode is now based on version 3.27.2 of the SQLite engine.
  • The ODBC driver activation no longer requires administrator privileges.
  • Improved compatibility with sandboxed applications for macOS.
  • Improved support for connection pooling.
  • Added the EnableSharedCache connection parameter.
  • Added the QueryTimeout connection parameter.

Version 3.0

  • The Direct mode is now based on version 3.26.0 of the SQLite engine.
  • The ODBC driver for macOS is now distributed as a PKG package.
  • The ODBC driver for Linux is now distributed as DEB and RPM packages.
  • Added the option to force the ODBC 2.x behavior.

Version 2.4

  • Added the option to return string types as Ansi or Unicode.
  • Improved compatibility with MS Access.
  • Improved compatibility with Tableau.
  • Improved compatibility with Omnis Studio.
  • Improved compatibility with Power Pivot.
  • Improved compatibility with DBeaver.

Version 2.3

  • Improved performance of batch operations.
  • Added the UnknownAsString connection option to return fields of unknown type as strings.

Version 2.2

  • Added support for the Direct mode on Linux.
  • Added support for database encryption on Linux.
  • Added support for the Direct mode on macOS.
  • Added support for database encryption on macOS.
  • Improved compatibility with SAS JMP.
  • Improved compatibility with MS Power Query.
  • Added support for the OUTER JOIN macros in SQL queries.
  • Added support for the DateTime macros in SQL queries.
  • Added support for the Scalar function macros in SQL queries.

Version 2.1

  • Improved compatibility with MS Visual Studio.
  • Improved compatibility with MS FoxPro.
  • Improved compatibility with MapInfo.
  • Improved compatibility with LibreOffice.
  • Improved compatibility with Qlik.
  • Improved compatibility with Delphi and C++Builder.
  • Improved support for MS Access linked tables.

Version 2.0

  • Added support for Linux.
  • Added support for macOS.
  • Improved backward compatibility of SQLExecDirect with ODBC 2.x.
  • Improved compatibility with MS Excel.
  • Improved compatibility with ODBC 2.x.

Version 1.2

  • Improved compatibility with Microsoft Visual Studio.
  • Improved compatibility with Microsoft Office.
  • Improved compatibility with Microsoft SQL Server Management Studio.
  • Improved compatibility with Crystal Reports.
  • Improved compatibility with QlikView.

Version 1.1

  • Improved performance.

Version 1.0

  • First release of ODBC Driver for SQLite.
  • Added support for:
    • Windows 32-bit
    • Windows 64-bit