QUESTION POSED ON: 09 March 2004
I have configured Replication Activity (LEI 3.2) to transfer data from a Notes database to SQL Server 2000 (one way only) using an ODBC connection (System DSN configured on an LEI server). It works great when run the first time with an empty SQL DB. When the activity is run again to update, it gives me the error:
Error: [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt, Connector 'OBTREEE SQL connection', Method -Insert- (84)
I've researched the error on Microsoft and am assured that the SQL Server is running the correct MDAC version, etc.
Do you know if LEI 3.2 using ODBC connection definitely works with SQL 2000? Any help would be very much appreciated.
|