I have configured Replication Activity (LEI 3.2) to transfer data from the Notes database to the SQL Server 2000 (one way only). When the activity is run, it gives me the error:
Error: [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt, Connector 'testmagic', Method -Update- (84)I successfully did an update on the same databases with DECS.
It sounds like the problem may be caused by DECS and LEI conflicting for a connection to the SQL Server database or an ODBC configuration problem. Check the SQL Server's DSN entry to ensure it is set up as a system DSN and not a user DSN. If the ODBC connection was set up incorrectly, try the LEI job again. If it was OK, shut down DECS and try the LEI job again. I think you'll find one of this issues is causing the problem.
This was first published in October 2003