I am getting a crappy error :( I can reproduce it but it is only a
select statement after an insert. Using VB 3.0 and SQL Server version 6
The vb/odbc client error is :
ODBC--call failed. [Microsoft][ODBC SQL Server
Driver][dbnmpntw]ConnectionWrite (GetOverLappedResult()). (#232)
[Microsoft][ODBC SQL Server Driver]Communication link failure (#232)
The SQLSRVR error log error is:
spid12 Error : 1203, Severity:20, State:2
Caller of lock manager is incorrectly trying to unlock an unlocked
object. spid=12 locktype=4 dbid=1 lockid=1356531866
It is always EXACTLY the same lockid every time.
Any Ideas ?