Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shuvipowers
Starting Member
1 Post |
 Posted - 2014-08-15 : 10:17:23
|
| I'm ODBC connection with SQL Server Native Client 11.0 to call stored procs that in turn are calling my SSIS packages to import data. I have 3 stored procs that are being called one after another. I keep encountering the following error message. I've ensure that I capture the result each of the stored proc is returning. I also tried to enable MARS in my connection string by adding this (MultipleActiveResultSets=True;MARS_Connection=yes;). I'm not sure if that is correct. Any ideas on how I can resolve this error?Error Number: S1000[Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmtThanks!Shuvi |
|
|
|
|
|
Connection is busy with results for another hstmt