Q

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

Dig deeper on LEI and DECS for Lotus Notes Domino

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchWindowsServer

Search400

  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...

SearchEnterpriseLinux

SearchDataCenter

SearchExchange

SearchContentManagement

Close