ODBC driver for SQLite
History
[email protected]
4.5.2 12-Nov-24
Fixed bug with re-activation ODBC driver via another Windows user
4.5.1 28-Mar-24
Fixed the issue when establishing a connection with a connection string that contains unsupported parameters
4.5.0 14-Mar-24
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
4.4.0 03-Oct-23
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
4.3.2 17-Aug-23
Improved compatibility with 4D in macOS
Fixed bug with getting data in DBeaver
Fixed Windows XP installation bug
4.3.1 15-May-23
Added support for SQL_ATTR_MAX_ROWS attribute
Improved compatibility with Visual Basic in Visual Studio
Fixed bug with handling DATETIME values that contain the "Z" suffix in milliseconds
Fixed bug in returned metadata for SQL statements that contain JOINs
Fixed an issue with an incorrect data type of a field that was selected with an alias
4.3.0 17-Nov-22
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
4.2.1 05-Jan-22
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
4.1.1 08-Jul-21
MSI installer for deploying through GPO is added
4.0.1 25-May-21
Apple Silicon M1 is supported
Compatibility with macOS Big Sur is improved
The Integer as BigInt option for mapping INTEGER to SQL_BIGINT is added
The JournalMode = jmDefault option is added
Bug with modifying data using the Linked Server is fixed
3.2.1 07-Dec-20
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
3.1.3 08-Apr-20
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
3.1.2 04-Oct-19
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
3.0.1 08-Jan-19
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
2.4.9 16-Jul-18
Possibility to show used connection string in the connection dialog is added
2.4.8 14-Jun-18
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
2.3.7 26-Feb-18
Performance of batch operations is significantly improved
The UnknownAsString connection option for returning fields of unknown type as a string is added
2.2.6 23-Oct-17
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
2.1.5 22-Jun-17
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
2.1.4 29-Nov-16
Compatibility with Microsoft SQL Server Reporting Services is improved
2.1.3 26-Oct-16
Compatibility with MS Visual Studio is improved
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
2.0.2 05-Apr-16
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
2.0.1 15-Mar-16
Linux is supported
macOS is supported
Backward compatibility of SQLExecDirect with ODBC 2.x is improved
1.2.4 06-Jan-16
Compatibility with Microsoft Visual FoxPro is improved
1.2.3 06-Nov-15
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
1.1.2 16-Jul-15
Performance is improved
Bug with access violation when using ADO is fixed
Bug with calling the same SQL statement for several times is fixed
1.0.1 20-May-15
Initial release of ODBC Driver for SQLite
Windows 32-bit is supported
Windows 64-bit is supported
© 2015-2024 Devart. All rights reserved.