Hi guys,
What am I doing wrong? This is on Etch.
First I got sqlitebrowser, created a new sqlite database, then imported my
data into it as csv. Seems fine - at least, it can be browsed using
sqlitebrowser.
Second, apt-get install iodbc and the sqlite odbc libraries. The mysql ones
for good measure. Verify they are there.
Fire up iodbcadm-gtk and try to set the DSN of my database. It want to know
which driver to use, and it cannot see either the sqlite ones or the mysql
ones. So I suppose its first necessary to add one.
When I point to what seem like reasonable candidates in /usr/lib/odbc, it
rejects them because an error occurred when trying to add the driver, invalid
keyword pairs. Googling suggests an authorization error, but the same thing
happens with the root account.
It seems like you have to define a driver before you can do a DSN, however I
can't figure out how to define a driver.
Any suggestions gratefully received. After this, assuming we ever get over
it, comes the fun part of talking to the thing from my programming language.
All keeps the blood flowing in the brain!
Peter