/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



Never miss a thing. Make Yahoo your homepage.