/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

____________________________________________________________________________________ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping