[unixODBC-support] Defining DSN and Driver

Rich Shepard rshepard at appl-ecosys.com
Mon Jan 19 21:44:10 GMT 2015


On Mon, 19 Jan 2015, Nick Gorham wrote:

>>     /etc/obcinst.ini

   typo: that's /etc/odbcinst.ini
> Check the lib loads with
> dltest /usr/local/lib/libsqlite3odbc.so SQLConnect

[rshepard at salmo ~]$ dltest /usr/local/lib/libsqlite3odbc.so SQLConnect
SUCCESS: Loaded /usr/local/lib/libsqlite3odbc.so
SUCCESS: Found SQLConnect

   Forgot that there's also /etc/unixodbc.ini with

[SQLITE3]
Description = SQLite3 ODBC Driver
Driver      = /usr/local/lib/libsqlite3odbc.so
Setup       = /usr/local/lib/libsqlite3odbc.so
Threading   = 2


> The
>
> Driver=SQLite3
>
> Needs to match the entry in odbcinst.ini
>
> [SQLite]
>
> So I would try
>
> Driver=SQLite

   Just tried that, and changed to [SQLite3], neither fixed the problem.

THanks,

Rich


More information about the unixODBC-support mailing list