Hello,
I continue to have "database is locked errors" when running an application
which accesses a SQLite dabase on a network.
I have tried many of the connection string options: pooling, changing default
time out.
I just recently tried a block of code which does a BeginTransaction and Commit.
Before I did not use this. However it does not seem to have an effect
on the locking problem.
string sql;
sql = "UPDATE APPOINTMENTS SET " +
// "PatientID=" + myPatientID + "," +
"TimeStampIsSeenByMA='" + nowString + "'" +
" WHERE (" +
"PatientID=" + myPatientID + " AND Date=" + "'" +
dateString + "'" + ")";
SQLiteCommand command = new SQLiteCommand(sql, OMConnection.sqConn);
int numRowsAffected = 0;
SQLiteTransaction tran;
tran = OMConnection.sqConn.BeginTransaction(false);
numRowsAffected = command.ExecuteNonQuery();
command.Dispose();
tran.Commit();
Please let know if there are any other solutions to this database locking
problem as used on a network.
Thanks
Mike
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
