<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:courier,monaco,monospace,sans-serif;font-size:10pt"><div>/etc/odbc.ini:<br>[sqlite1]<br>Description = SQLite<br>Driver = SQLite<br>Database = /root/test.db<br>Timeout = 9000<br>Trace = Yes<br>TraceFile = /tmp/sqlite.log<br><br>/etc/odbcinst.ini:<br>[SQLite]<br>Description = SQLite ODBC Driver<br>Driver = /usr/local/lib/libsqlite3odbc.so<br>Setup = /usr/local/lib/libsqlite3odbc.so<br><br>openser.cfg:<br>modparam("avpops", "db_url", "unixodbc://localhost/sqlite1")<br><br>What's the correct format for
specifying the DSN when using SQLite with ODBC?<br>SQLite doesn't use a user/password or host.<br><br>I tried the above, "unixodbc://localhost/sqlite1" and openser barfs with:<br>ERROR:unixodbc:new_connection: failed to connect<br><br>I also tried:<br>modparam("avpops", "db_url", "unixodbc://sqlite1")<br><br>and openser barfed with:<br>new_db_id: Error while parsing database URL: unixodbc://sqlite1<br><br>What's the correct format? Is it even supported in Openser 1.2.0?<br><br>Thanks,<br>Doug<br><br></div></div><br>
<hr size=1>Never miss a thing. <a href="http://us.rd.yahoo.com/evt=51438/*http://www.yahoo.com/r/hs"> Make Yahoo your homepage.</a></body></html>