I use the excellent Radio Downloader application
(
http://www.nerdoftheherd.com/tools/radiodld/), and have written a Java
application of my own which accesses Radio Downloader's SQLite database.
Recently I installed the latest version of Radio Downloader, which
includes a change to "
Update the SQLite provider for ADO.NET to version 1.0.82."
Now, my application cannot read the database; it connects successfully,
but when it tries to read a table an error is returned "Table episodes
does not exist".
I can read the database using either a graphical
SQLite client, or the SQLite command line, and both confirm that table
episodes does exist. So there seems to be an incompatibility between the
provider version now used by Radio Downloader and the JDBC driver (I am
using v3.7.2). However, I don't understand enough about the different
versions involved to resolve this. Does anyone have any suggestions
please?
Thanks,
Jeremy