there is a strange problem on a user's computer with
SQLite or the data provider I am trying to hunt down.
It manifests itself with the following (mangled)
Finisar.SQLite.SQLiteException: unable to open database
dataSet, String srcTab...
Sorry that it is not more, but as the problem happens
on a computer I don't have access to, all I have is
a screenshot showing the above mentioned part of the
Now the code involved does something like this:
SQLiteConnection* conn = new SQLiteConnection(S"Data
SQLiteDataAdapter* da = new SQLiteDataAdapter();
DataSet* ds = new DataSet();
[... configure data adapter, fill data set ...]
It looks like the call to Update fails. The problem
is, it does not always fail. I searched at Google,
SourceForge, the SQLite homepage, and at Gmane for
the error message in the exception and most of the
reports were concerned with unsufficient permissions
for the directory the database file lives in. Now
in my case the file resides in a directory below
"Documents and Settings\<user>\Application Data"
which was created together with the database file
by the application using the database. The user has
a restricted account, but I guess he should have
write permissions for both the database file and the
directory it resides.
The funny thing is that the user reportedly is able
to update the database a few times before the
exception is thrown. Also, he does not have any
problems if he runs the application with an
administrator account. All of this on Windows XP.
On other computers the application doesn't have this
problem, even with restricted accounts. But I could
not emulate the environment because I don't know the
exact settings on the computer in question.
So I am a bit baffled what the problem is and I
got my hands tied because I don't have access to
the computer for in-depth debugging. I don't even
know if it's a problem with SQLite itself or the
data provider. Maybe somebody here has encountered
this problem before and is able to help pin down the
Thanks in advance,
Log in to post a comment.