[sqlite] Locking errors on network

[Mike McWhinney]

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