We are migrating our databases from MS Access to SQL Server 2005 and using the SQL Native Client ODBC driver.
When I run an Actuate report having multiple datastreams I get the following error message from SQL Server:
Error generated by the connected data source. Connection is busy with results for another command.
Would anyone know how to solve this error? Is there a configuration setting in SQL Server to enable processing of multiple result sets?
Thanks.
When I run an Actuate report having multiple datastreams I get the following error message from SQL Server:
Error generated by the connected data source. Connection is busy with results for another command.
Would anyone know how to solve this error? Is there a configuration setting in SQL Server to enable processing of multiple result sets?
Thanks.