Softpedia >Windows >Internet >Servers >Database Utils >SQLite ODBC driver >  Changelog

SQLite ODBC driver Changelog

What's new in SQLite ODBC driver 4.5.0

Mar 15, 2024
  • 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 in SQLite ODBC driver 4.4.0 (Oct 4, 2023)

  • Now the Direct mode is based on the version 3.42.0 of the SQLite engine
  • Fixed bug with driver license validation for Linked Server in MSSMS

New in SQLite ODBC driver 4.3.2 (Aug 18, 2023)

  • Improved compatibility with 4D in macOS
  • Fixed bug with getting data in DBeaver
  • Fixed Windows XP installation bug

New in SQLite ODBC driver 4.3.1 (May 17, 2023)

  • Added support for Private App authorization
  • Added support for SQL_ATTR_MAX_ROWS attribute
  • Improved compatibility with Linked Server in SQL Server
  • Improved compatibility with Visual Basic in Visual Studio
  • Improved compatibility with Alteryx
  • Improve MS Access linked tables support
  • Fixed bug with SELECT that contains JOIN for Linked Tables in MS Access

New in SQLite ODBC driver 4.3.0 (Nov 18, 2022)

  • 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
  • Fixed bug when a connection string parameter value contains a single quote
  • Fixed an issue with adding DSN in PowerShell
  • Fixed an issue with rows deleting

New in SQLite ODBC driver 4.2.1 (Jan 5, 2022)

  • 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
  • Fixed an issue with updating date and time fields in MS Access

New in SQLite ODBC driver 4.1.1 (Jul 12, 2021)

  • MSI installer for deploying through GPO is added
  • Bug with executing the "call" macro with a stored procedure in PostgreSQL 11 and later is fixed

New in SQLite ODBC driver 4.0.1 (May 26, 2021)

  • Apple Silicon M1 is supported
  • Compatibility with macOS Big Sur is improved
  • The JournalMode = jmDefault option is added
  • Bug with modifying data using the Linked Server is fixed

New in SQLite ODBC driver 3.2.1 (Dec 9, 2020)

  • 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 in SQLite ODBC driver 3.1.3 (Apr 8, 2020)

  • Compatibility with Power Pivot is improved
  • Compatibility with Visual Basic is improved
  • Compatibility with RStudio is improved
  • Bug with modifying data using SQLSetPos is fixed
  • Bug with fetching by Bookmark is fixed

New in SQLite ODBC driver 3.1.2 (Oct 7, 2019)

  • 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
  • Support for connection pooling is improved
  • The EnableSharedCache connection parameter is added
  • The QueryTimeout connection parameter is added

New in SQLite ODBC driver 3.0.1 (Jan 9, 2019)

  • 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 in SQLite ODBC driver 2.4.9 (Jul 17, 2018)

  • Possibility to show used connection string in the connection dialog is added

New in SQLite ODBC driver 2.4.8 (Jun 15, 2018)

  • 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 in SQLite ODBC driver 2.3.7 (Feb 27, 2018)

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

New in SQLite ODBC driver 2.2.6 (Oct 24, 2017)

  • 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 in SQLite ODBC driver 2.1.5 (Jun 22, 2017)

  • Compatibility with Adobe ColdFusion is improved
  • Several issues with data modification in Microsoft SQL Server Management Studio are resolved
  • Now "." is a decimal separator for numbers with floating point by default

New in SQLite ODBC driver 2.1.4 (Dec 7, 2016)

  • Compatibility with Microsoft SQL Server Reporting Services is improved

New in SQLite ODBC driver 2.1.3 (Dec 7, 2016)

  • 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 in SQLite ODBC driver 2.0.2 (May 3, 2016)

  • 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 in SQLite ODBC driver 2.0.1 (Mar 23, 2016)

  • Backward compatibility of SQLExecDirect with ODBC 2.x is improved

New in SQLite ODBC driver 1.2.4 (Jan 8, 2016)

  • Compatibility with Microsoft Visual FoxPro is improved

New in SQLite ODBC driver 1.2.3 (Nov 21, 2015)

  • 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 in SQLite ODBC driver 1.1.1 (Jun 13, 2015)

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