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