[unixODBC-support] Defining DSN and Driver

Nick Gorham nick at lurcher.org
Mon Jan 19 21:56:49 GMT 2015


On 19/01/15 21:44, Rich Shepard wrote:
> 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

Try using isql

isql -v no-mdf-banquetdb

What does that report?

-- 
Nick


More information about the unixODBC-support mailing list