Hi



I have an MFC app using ODBC to connect to SQL Server 2005 Express
edition. The App connects in 20 threads and uses a same database object.


I am getting "Connection is busy with results for another hstmt" error
msg in the app.



What is the maximum concurrent connections which we can have in SQL
Express 2005?



Is there any thing which I can change in SQL Server to address this
issue?



I am not using any new features of SQL Express, so I have not tried to
MARS.



Please let me know what to do in such scenario?



Thanks in advance

Prasanth M.P




MS Sql Server LazyDBA home page