ITX with SQLite via ODBC/JDBC
In this practical demonstration, I install, configure and run an SQLite database and connect to it from the DB Browser for SQLite package as well as Eclipse and of course ITX
Download and extract all the required files
Run the DB Browser for SQLite package to create an initial database, table and data rows
Create a 64bit ODBC entry and verify connectivity with Design Studio tools (Database Interface Designer)
Connect the Eclipse Database perspective to the instance to allow easy admin
Connect an ITX Map via JDBC to retrieve data
Links:
sqlite-dll-win64-x64-3400100.zip = https://www.sqlite.org/download.html
DB.Browser.for.SQLite-3.12.2-win64.zip = https://sqlitebrowser.org/dl/
sqlite-jdbc-3.40.1.0.jar = https://github.com/xerial/sqlite-jdbc...
sqliteodbc_w64.exe = http://www.ch-werner.de/sqliteodbc/