Jocelyn Fiat
f619727997
Now we have ODBC .. that accepts various connection string (including SQLite, MySQL,...) And EiffelStore+MySQL. Updated sql scripts to work with MySQL, and SQLite. Added a sql_statement (s: STRING): STRING that converts ROC sql statement to fit the underlying database engine. mostly to adapt incompatibilities such as AUTO_INCREMENT for MySQL and AUTOINCREMENT for SQLite by default SQL script should be written following MySQL SQL syntax. Warning: to use ODBC persistence driver, it has to be installed on the target machine.
27 lines
679 B
Markdown
27 lines
679 B
Markdown
SQLite ODBC.
|
|
|
|
Install the odbc driver from http://www.ch-werner.de/sqliteodbc/
|
|
|
|
Current version
|
|
sqliteodbc.exe -- Win32
|
|
sqliteodbc_w64.exe -- Win64
|
|
|
|
|
|
Test the ODBC driver using Firefox SQLite DBManager https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/
|
|
|
|
1. Open the odbc manger from Windows, create a new database using the SQLite3 ODBC driver and then open it from Firefox.
|
|
|
|
|
|
EiffelStore + SQLiteODBC.
|
|
|
|
Connection String: https://www.connectionstrings.com/sqlite3-odbc-driver/
|
|
|
|
"Driver=SQLite3 ODBC Driver;Database=./cms_lite.db;LongNames=0;Timeout=1000;NoTXN=0;SyncPragma=NORMAL;StepAPI=0;"
|
|
|
|
Edit the database location based on your system.
|
|
|
|
|
|
|
|
|
|
|