This is a discussion on Connection is busy with results for another hstmt within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> Hi i've made a multithread application in which a connection is being shared by multiple threads and at one ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hi i've made a multithread application in which a connection is being shared by multiple threads and at one time multiple threads may be using the connection to query database. i sometimes get this error. "Microsoft OLE DB Provider for ODBC Drivers Error -2147467259[Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt" i thouhght that SQL Coms have ability to handle multiple threads. or may be its my usage..Should i restrict connection usage by critical section ..or what else can be the solution. to maximize the connection usage. Regards Usman Jamil |
| Thread Tools | |
| Display Modes | |
|
|