SQLite "Database Locked"

[DjDeep00 0]

I was wondering if there is any way that I can prevent the "Database Locked" message from happening?

Currently I am using a SQLite database which is located on a network shared folder and the SQLite.exe resides on the person's local machine. I have bout 8 people accessing the database at one time. They all are doing updates, inserts, and basic select query to the database.

Is there a way to queue up people or something else and not get the "Database Locked" message. Please help.

[DjDeep00 0]

Bump....Anyone?

[webmedic 0]

well sqlite is not intended for concurrent connections.

write some failovers into your apps that if they get that error to simple wait a few seconds and retry the connection.

Also make sure each app closes the connection properly after it does it's thing.

This should help some.

[McGod 0]

You can have more then one connection, heres some tips:

When using _SQLite_Query() make sure to use:

_SQLite_QueryFinalize() and _SQLite_QueryReset ()

Make sure every Query does that.

Execs do not matter.

[DjDeep00 0]

Thanx Guys! I ended up writing a function that when it finds the "database locked" message, it just retry's the SQL until its good.