        Name: sqlite3odbc
     Purpose: Port of SQLite driver for SQLite3

This is version 0.99991 of the SQLite3 database driver.


RISC OS notes for 0.99991
-------------------------
This port is built against SQLiteLib3_54_0 (SQLite 3.54.0), the iODBC
headers, CLibSupport and TCPIPLibs. It installs as
SQLiteODBC099991, so it can be installed next to the 0.67 driver.
The wide character (W) ODBC entry points are not built, as for 0.67.


Installation
------------
The driver directory contains the driver (SQLiteODBC099991) which should
be installed using ODBCMan.


odbc/ini and odbcinst/ini files
-------------------------------
These files contain example entries for the odbc/ini and odbcinst/ini files.

These files can be configured using ODBCMan but the entries supplied here
are to give you an idea of what is needed to get basic connectivity up
and running.

Database is the full pathname of the database file. Use
Driver = <ODBC$DriverDir>.SQLiteODBC099991.sqlite3odbc.

Set UnloadSafe to 1 so that !ODBC unloads the driver when the last
client disconnects. The driver can only be unloaded if SQLDisconnect
succeeds, which needs any open transaction to be ended and all
statements freed first.


sqlite3
-------
The sqlite3 command line tool is not built by this project. Its source
is c.shell in Projects.Libraries.Database.SQLiteLib3_54_0. Full
documentation is available on the SQLite site at https://www.sqlite.org


Building
--------
Requirements: Acorn C compiler
              Acorn libfile
              Acorn C library (32 bit)
              Rink
              TCPIPLibs (32 bit)
              CLibSupport
              iODBC headers
              SQLite 3.54.0 library (Projects.Libraries.Database.SQLiteLib3_54_0)

TCPIPLibs and rink need to be available to compile this. The resulting
sqlite3odbclnk file is placed into the driver shared resource,
!ODBC.drivers.SQLiteODBC099991.
