Release Notes for the GM - SQLite ODBC Driver
- 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.
- 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 management 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.