SQL Inbound Adapter Errors
Hi,
I created a BS with a SQL Inbound Adapter.
Query = "SELECT rowid, fname ,lname,datesent
FROM labs
WHERE datesent IS NOT NULL"
DeleteQuery = " update labs set datesent = Getdate() where rowid = ?"
KeyFieldName = "rowid"
i am getting the following errors.
"NOT assuming network disconnect error based on: Gateway failed: DropStatement."
"Skipping previously errored row '235'"
"Assuming network disconnect error based on: SQLState: (HY000) NativeError: [0] Message: [Microsoft][SQL Server Native Client 11.0]Connection is busy with results for another command"
Why is this not working?
Thanks