Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ward0093
Starting Member
15 Posts |
 Posted - 2008-03-17 : 16:46:17
|
| We have had a SQL server 2005 database up and running for some time and now we are getting this error:[The server will drop the connection, because the client driver has sent multiple requests while the session is in single-user mode. This error occurs when a client sends a request to reset the connection while there are batches still running in the session, or when the client sends a request while the session is resetting a connection. Please contact the client driver vendor.]We use MARS in our Windows Application (.NET 2.0) and can not seem to figure out what is going on...After this error shows up in the event viewer, we get a second error (milliseconds later) in our application. "A severe error occurred on the current command. The results, if any, should be discarded."i really need help on this one... it seems it is not with our SP but the connection to SQL Server 2005 Express and using MARS... i double checked the connection string and it is all setup correctly and we are in Multi-User Mode.PLEASE HELP!ward0093 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-03-17 : 17:39:19
|
| try disabling connection pooling. from the error message this looks like a connection pooling issue._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
 |
|
|
ward0093
Starting Member
15 Posts |
Posted - 2008-03-17 : 21:13:20
|
what would Connection Pooling do to it if we are setting up MARS in the connection string?quote:
Originally posted by spirit1
try disabling connection pooling. from the error message this looks like a connection pooling issue._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com
|
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-03-18 : 06:15:15
|
| i don't know. i've never seen this error before. so i'm making a guess baesd on the error message.this part of the error message "or when the client sends a request while the session is resetting a connection"makes me think that a driver closed the connection and returned it to the pool while a request was being still made._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
ward0093
Starting Member
15 Posts |
Posted - 2008-03-18 : 07:34:13
|
Makes sense.. tring it nowquote:
Originally posted by spirit1
i don't know. i've never seen this error before. so i'm making a guess baesd on the error message.this part of the error message "or when the client sends a request while the session is resetting a connection"makes me think that a driver closed the connection and returned it to the pool while a request was being still made._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com
|
|
|
|
|
|
|
Using MARS and sql server..