Hi Richard,
Am I trying to work with sqlite through a gui? Not quite. It was probably less than clear.
I have the database all set up. I also have an sqlite ODBC driver installed - the one that comes in the Etch repositories.
The programming language doesn't do sqlite natively, it only does ODBC. Yes, probably I should get another language one of these days....
However, all that is OK - I can manage the language, and I can manage to use the ODBC commands and functions it has built in, but to make it talk to the database, I need a DSN apparently. From synaptic, I installed the sqlite ODBC driver, and on checking, it really does seem to be there in /usr/lib. This is where the problems start though.
I can't make a DSN for the database, because I can't see how to add the driver using iodbcadmin-gtk. In the gui, it simply doesn't see it even if pointed at it, and it crashes out with the error when you try. So I can't address the database from the language using the ODBC functions, with no DSN.
I was attracted to doing this step with the gtk interface that comes with iODBC, because there seemed to be a lot of things to go wrong if you edit it by hand. And I'm very puzzled about why having installed a couple of ODBC database drivers, it cannot see them.
Maybe the answer is give up on iODBC and edit the configuration file by hand, and then if that doesn't work, another option is to go out to the shell. Apparently with sqlite you can go out to shell, call it, and then pass a command to it, and that can be a script. This will have to do if I can't get ODBC to work. Which does seem increasingly problematic.
Cheers
Al