gauls

Hi i have problem with accessing the third party component(for data access) in case of multi-user one user can gets values and the second one gets an exception of

System.InvalidOperationException: The SqlCommand is currently busy Open, Fetching.

Now this is thrown from the component cause i have no access to the database directly.

Is there a different way to access the components from webservice thats running under IIS


Re: ADO.NET (Pre-release) System.InvalidOperationException: The SqlCommand is currently busy Open, Fetching

Clemens Vasters - MSFT

Sounds like there's shared access to the same SqlCommand. That's an ADO.NET problem and I'm moving this thread to the ADO.NET forum.




Re: ADO.NET (Pre-release) System.InvalidOperationException: The SqlCommand is currently busy Open, Fetching

Kevin Hoffman

If its a third party component, you may be out of luck. However, have you tried modifying the SQL connection string to enable MARS (Multiple Active RecordSets)