/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
_______________________________________________
Users mailing list
Users@lists.openser.org
http://lists.openser.org/cgi-bin/mailman/listinfo/users

Reply via email to