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