Ask the Expert

Getting error when transferring data from Notes DB to SQL Server 2000

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: