/etc/odbc.ini:
[sqlite1]
Description = SQLite
Driver = SQLite
Database = /root/test.db
Timeout = 9000
Trace = Yes
TraceFile = /tmp/sqlite.log
/etc/odbcinst.ini:
[SQLite]
Description = SQLite ODBC Driver
Driver = /usr/local/lib/libsqlite3odbc.so
Setup = /usr/local/lib/libsqlite3odbc.so
openser.cfg:
modparam("avpops", "db_url", "unixodbc://localhost/sqlite1")
What's the correct format for
specifying the DSN when using SQLite with ODBC?
SQLite doesn't use a user/password or host.
I tried the above, "unixodbc://localhost/sqlite1" and openser barfs with:
ERROR:unixodbc:new_connection: failed to connect
I also tried:
modparam("avpops", "db_url", "unixodbc://sqlite1")
and openser barfed with:
new_db_id: Error while parsing database URL: unixodbc://sqlite1
What's the correct format? Is it even supported in Openser 1.2.0?
Thanks,
Doug