We have installed a package developed by another company and sometimes
(when the server is with a big rate of transactions), we are seeing
the following messages in package debug file:
2004-04-22 14:23:27 3056:
------------------------------------------------------------
2004-04-22 14:23:27 3056: rlm03000: ls_PutOneRecord: Failed inserting
[04113SO07236054]
2004-04-22 14:23:27 3056: ODBCSetCursorName[3056]: Failed specifying
cursor concurrency to statement handle 1 for 'ls_rep_add'
2004-04-22 14:23:27 3056: dbc01003: ODBCSetCursorName[3056]:
ls_rep_add generated SQL error state: 24000
2004-04-22 14:23:27 3056: dbc01002: [Microsoft][ODBC Driver Manager]
Invalid cursor state
2004-04-22 14:23:27 3056: odbcFilterConnectErrors[3056]: set the
iState to ODBC_DISCONNECT for <24000>
2004-04-22 14:23:27 3056: Function Return Code [00001] ODBC_ERROR
2004-04-22 14:23:27 3056: Operation [00000] ls_PutOneRecord
2004-04-22 14:23:27 3056: Primary Return Code [00000] 00000
2004-04-22 14:23:27 3056: Secondary Return Code [0000000001] 00000
2004-04-22 14:23:27 3056:
------------------------------------------------------------
When this message appears in the app debug file we are loosing some
inserts that the application do in the database.
The MS SQL server configuration is:
4 Pentium 760Mhz 4 GB RAM
SQL 2000 Standard Edition 8.00.760 SP 4
MDAC 2.7 driver ODBC SQLSRV32.dll 2000.81.9031.14 15/11/2002
Any tip will be welcome,
Thanks in advance,
Reis