Release Notes for the GM - SQLite ODBC Driver

Version 1.3.0 released 11. Mar 2025

Internal error (access violation, introduced by v1.2.2) when calling the schema functions (SQLTables, SQLColumns, SQLForeignKeys etc.) has been fixed.
When executing a SQL containing more than one statement:
- In prior versions only the first statement was executed.
- Starting with this version ALL statements are executed. A new connection string value MaxStmtsPerSQL has been introduced allowing to limit the number of statements executed per SQL. 0 = ALL statements are executed (the default). Add MaxStmtsPerSQL=1 to the connection string to get the behavior of prior versions.
Processor requirements raised to:
- 32-Bit: CPU ≥ Pentium-M (~2003), FPU ≥ SSE4.2 (~2007)
- 64-Bit: CPU ≥ X86-64-V2 (~2000), FPU ≥ SSE4.2 (~2007)

Version 1.2.2 released 21. Feb 2025

The error Unable to write value, valueName: "AllowCreate", value: "1", when closing the data source dialog via the [ Ok ] button, has been fixed.
New feature in the data source dialog to check if there is a newer version of the driver available.
Latest version v3.49.1 of SQLite DLL's included.

Version 1.2.1 released 31. Oct 2024

The search for ODBC escape sequences inside the SQL statements was not thread safe anymore, now it is again.
Additional internal optimizations further improve overall performance.

Version 1.2.0 released 22. Oct 2024

The search for ODBC escape sequences inside the SQL statements is faster now, resulting in an overall performance gain of ~10% or more when executing many large SQL statements.
Setting the value of SQL_ATTR_NOSCAN via SQLSetStmtAttr can be used to turn the search for ODBC escape sequences off (SQL_NOSCAN_ON) or on (SQL_NOSCAN_OFF).
New connection string value IgnoreOdbcESC=True|False recognized, to set the search for ODBC escape sequences off|on for all statements that are executed on that connection.
Two additional data types SQL_TYPE_DATE and SQL_TYPE_TIME returned by SQLGetTypeInfo now (SQL_TYPE_TIMESTAMP was already returned by prior versions).
Latest version v3.47.0 of SQLite DLL's included.

Version 1.1.0 released 15. Jun 2024

New connection string value BusyTimeout to set the maximum time (in [milliseconds]) to wait for statements of other connections to finish before the execution of statements on this connection is aborted. This will call sqlite3_busy_timeout(...) after the creation of the connection. The default value is 3000 (3 seconds). Note: The previous version 1.0.0 behaved as if BusyTimeout=0 was used (immediately fail if any other statement is executing).
The error message box when using the Test Connection button of the DSN config dialog did not show the actual error message.
Newly introduced connection string values where set to empty when opening an old DSN entry, not having these values, with the config dialog.
No duplicate parts in the error messages anymore.
Database file name included in error message on file not found errors.
Latest version v3.46.0 of SQLite DLL's included.

Version 1.0.0 released 03. Jan 2024

Fast, stable native code (build with freePascal).
Thread safe. All objects inside the driver are internally secured by critical sections, so they can safely accessed by multiple threads.
Conforms to ODBC standard 3.5.
Unicode: The internal string type of the driver is Unicode (Utf-16). It exports only the SQLXxxxxW functions. But it converts string data to ANSI if an application wants character data as SQL_C_CHAR (instead of SQL_C_WCHAR).
Support for Date, Time and Datetime datatypes.
All important SQLite flags can be specified in the Connection strings.
Easy to use dialog to create or change ODBC data source entries in the ODBC administration of the system.
Supports SQLSetPos with operations SQL_ADD, SQL_UPDATE, SQL_DELETE and SQL_REFRESH for tables with primary keys, when all primary key columns are in the select list of the statement.
Automatic data type conversions for almost all possible type combinations: application buffer datatype 🡘 database column datatype.
SQLite DLL's included in the installer.