What's New - ODBC Driver for SQLite

New features in ODBC Driver for SQLite 4.5

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

New features in ODBC Driver for SQLite 4.4

• Now the Direct mode is based on the version 3.42.0 of the SQLite engine

New features in ODBC Driver for SQLite 4.3

• Added support for SQL_ATTR_MAX_ROWS attribute
• Improved compatibility with Visual Basic in Visual Studio
• Added support for macOS 13 Ventura
• Now the Direct mode is 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

New features in ODBC Driver for SQLite 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 an ODBC installer on Windows 2000
• Now the Direct mode is based on the version 3.31 of the SQLite engine

New features in ODBC Driver for SQLite 4.1

• MSI installer for deploying through GPO is added

New features in ODBC Driver for SQLite 4.0

• Apple Silicon M1 is supported
• Compatibility with macOS Big Sur is improved
• The JournalMode = jmDefault option is added

New features in ODBC Driver for SQLite 3.2

• The Connect Mode connection option is added
• The Journal Mode connection option is added
• The Locking Mode connection option is added
• The Synchronous connection option is added

New features in ODBC Driver for SQLite 3.1

• Now ODBC driver is thread-safe
• Now the Direct mode is based on the version 3.27.2 of the SQLite engine
• Now ODBC driver activation does not require administrator privileges
• Improved compatibility with sandboxed applications for macOS
• Support for connection pooling is improved
• The EnableSharedCache connection parameter is added
• The QueryTimeout connection parameter is added

New features in ODBC Driver for SQLite 3.0

• Now the Direct mode is based on the SQLite engine version 3.26.0
• Now ODBC driver for macOS is distributed as a PKG package
• Now ODBC driver for Linux is distributed as DEB and RPM packages
• Possibility to force the ODBC 2.x behavior is added

New features in ODBC Driver for SQLite 2.4

• Possibility to return String Types as Ansi or Unicode is added
• Compatibility with MS Access is improved
• Compatibility with Tableau is improved
• Compatibility with Omnis Studio is improved
• Compatibility with Power Pivot is improved
• Compatibility with DBeaver is improved

New features in ODBC Driver for SQLite 2.3

• Performance of batch operations is significantly improved
• The UnknownAsString connection option for returning fields of unknown type as a string is added

New features in ODBC Driver for SQLite 2.2

• The Direct Mode for Linux is supported
• Database encryption for Linux is supported
• The Direct Mode for macOS is supported
• Database encryption for macOS is supported
• Compatibility with SAS JMP is improved
• Compatibility with MS Power Query is improved
• OUTER JOIN macros in SQL queries are supported
• DateTime macros in SQL queries are supported
• Scalar function macros in SQL queries are supported

New features in ODBC Driver for SQLite 2.1

• Compatibility with MS Visual Studio
• Compatibility with MS FoxPro is improved
• Compatibility with MapInfo is improved
• Compatibility with Libre Office is improved
• Compatibility with Qlik is improved
• Compatibility with Delphi & C++Builder is improved
• MS Access linked tables support is improved

New features in ODBC Driver for SQLite 2.0

• Linux is supported
• macOS is supported
• Backward compatibility of SQLExecDirect with ODBC 2.x is improved
• Compatibility with MS Excel is improved
• Compatibility with ODBC 2.x is improved
• Bug with Trial expiration in Microsoft SQL Server Management Studio is fixed
• Bug with incorrect data displaying in MS Access is fixed

New features in ODBC Driver for SQLite 1.2

• Compatibility with Microsoft Visual Studio is improved
• Compatibility with Microsoft Office is improved
• Compatibility with Microsoft SQL Server Management Studio is improved
• Compatibility with Crystal Reports is improved
• Compatibility with ClikView is improved

New features in ODBC Driver for SQLite 1.1

• Performance is improved

New features in ODBC Driver for SQLite 1.0

• First release of ODBC Driver for SQLite
• Windows 32-bit is supported
• Windows 64-bit is supported