DjDeep00 0 Posted November 30, 2006 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. Share this post Link to post Share on other sites
webmedic 0 Posted December 1, 2006 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. Share this post Link to post Share on other sites
McGod 0 Posted December 1, 2006 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. [indent][center][u]Formerly Chip[/u][/center]~UDFs~[/indent][u]IRC.au3 - Allows you to connect to IRC ServersINetCon.au3 - Connects/Disconnects/Check Status of InternetHardware Key - Creates a unique hardware hashScriptComm - Allows you to communicate between scripts using WM_COPYDATA[/u][indent]~Programs~[/indent][indent]SimonAu3ForumsIRC Bot~Web Site~Web Autoit Example[/indent][indent][b][/b][/indent][u][/u] Share this post Link to post Share on other sites
DjDeep00 0 Posted December 4, 2006 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. Share this post Link to post Share on other sites
