Jay Kreibich, Thank for your reply about sqlite3_busy_timeout. We
found that the sqlite 'database is locked' error message can be fixed by
updating two different tables in the two SQL Server 2005 client processes.
UPDATE mdMatchUp SET
MatchKey = master.dbo.mdMUIncrementalBuildKeyEx(@Incremental, Matchcode,
Zip, Last, First, Address, NULL, NULL, NULL, NULL, NULL, NULL),
@RetVal = master.dbo.mdMUIncrementalAddRecord(@Incremental),
Status = master.dbo.mdMUIncrementalGetStatusCode(@Incremental),
DupeGroup = master.dbo.mdMUIncrementalGetDupeGroup(@Incremental)
Perhaps, the problem we were experiencing with the sqlite 'database is locked'
error message is related to SQL Server 2005 locks.
The SQL Server 2005 extended stored procedure
master.dbo.mdMUIncrementalAddRecord(@Incremental) is a wrapper around the C/C++
code:
sprintf(Command,"INSERT INTO [Keys] ([Key], [Cluster], "
"[DupeGroup]) VALUES (\"%s\", \"%*.*s\", %d)",
MCKey,BlockSize,BlockSize,MCKey,DupeGroup);
while (Keys->Execute(Command)==SQLITE_BUSY) {
#if defined(__unix)
sleep(dRETRYDELAY);
#else
Sleep(dRETRYDELAY*1000);
#endif
}
Thank you.
_________________________________________________________________
Hotmail: Trusted email with powerful SPAM protection.
http://clk.atdmt.com/GBL/go/177141665/direct/01/
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
