December 1, 2003 at 1:38 pm
PLEASE HELP!!!!!
For some reason the logins on our sql server does not disconnect after we close out of sql server. After a while we start to get an ODBC error and then we have to manually disconnect people off the server. People are logged in more then once and I don't know why this is happening seen everyone has a unique log in and they log off every day. It seems to not disconnect when logging off. Can someone please help me?
Thanks,
Ayisat
Ayisat Idris
Ayisat Idris
December 1, 2003 at 2:18 pm
Did you check the error log?
Any unusual?
Did you or someone change anything in the server?
December 1, 2003 at 3:44 pm
No one has changed anything on the server. What we found out is, when you log in through the website is when we have this error.
Ayisat Idris
December 5, 2003 at 12:48 pm
You can check in two ways:
(1) Use the Enterprise Manager on the server and navigate to Management->Current Activity->Process Info to find out how many connections are still open to the webserver.
(2) It sounds like you have a connection pooling problem. This is a client side parameter, set in this case on the Webserver in Data Sources (ODBC)->Connection Pooling. Choose the ODBC connection type you are using, probably Sql Server. Double click to see the Connection Pooling Attributes. The Time in Pool should be about 60 seconds. If it is too high, you will have a problem like you described. If it is too low, the response time may be sporadically slow.
Remember this is a client side setting, not a server setting.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply