ETL and Data Integration tools - Modern ETL software for everyone

Hello Support

A question regarding the ODBC source.

I want to make updates on a MS Sql server. Adding records are no problem. But as fast as I try to update the following happens:

Adding new and Update old records I get this error message
Error 2011-04-07 13:11:51 Record:2 Line:2 HY000 [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt HY000 [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt

Update records only and the application hang.

Do you have a suggestion?

Best regards
Stefan

Hi.

Can you put

set nocount on
GO

Into sql before please

Let us know the outcome
Mike

Hi Mike

Works perfect now

I should have thought about “set nocount on” myself.

Stefan