Seems like the solution is just to call openDatabase at the top of any handler that's accessing the database. Seems a little clumsy to be constantly refreshing the db connection, but I presume it will work.
Any insight into this problem?
Code: Select all
local dbID
command openDatabase
put "/full/path/to/theData.data" into tDatabasePath
put revOpenDatabase("sqlite", tDatabasePath, , , , ) into dbID
end openDatabase