SQLServer Native Client Error "Connection Busy With Results From Another Command" in SSIS

Question

I'm getting a "Connection Busy With Results From Another Command" error from a SQLServer Native Client driver when a SSIS package is running. Only when talking to SQLServer 2000. A different part that talks to SQLServer 2005 seems to always run fine. Any thoughts?

Answer 1

Try this and this. The first is a KB article that might have some relavence and the second is a blog post that might give you some insight. Good luck.

Answer 2

Thanks Craig. I'm not sure the article are looking at the same cause, I'm only doing reads on a read only credential, but consensus in these and other sites I've read seem to scream update SQLServer 2000 to SP4 + HotFixes.

Answer 3

As I just found out, this can also happen on SQL 2005 if you do not have MARS enabled. I never even knew that it was disabled by default, but it is. And make sure you are using the "NATIVE OLEDB\SQL Native Client" connection type. If you're using the "OLEDB.1" type connection (or whatever...) MARS is not even an option, and you get the SQL 2000 behavior, which is nasty.

You can enable MARS by opening the connection properties, and clicking "All", and scolling down in Management Studio.

I know your question has long since been answered, but I'm just throwing this in for the next sucker like me who gets burned by this.