Click here to Skip to main content
15,888,322 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Please tell me how to manage more then one user in one database.
when login more then user then it occur error "Application pool TimeOut". please help me.
Posted
Comments
ZurdoDev 19-Sep-13 7:49am    
Why would your application pool timeout when a user logs in?
Abhilask kumar 19-Sep-13 8:17am    
I Don't know. after 3-4 user logon and logout then show this message at login time "Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were".
ZurdoDev 19-Sep-13 8:23am    
This is the SQL pool, not application pool. You have SQL issues. Check with your db admin.
Abhilask kumar 19-Sep-13 8:24am    
how to check db admin and what.
ZurdoDev 19-Sep-13 8:29am    
Your db admin is a person. Ask them. For some reason your SQL is running out of connections. Perhaps your code is not closing them properly. You should also check that.

1 solution

Try to use your connection string is as below on your web.config file.

XML
<connectionStrings>
   <add name="MyDb" connectionString="Server=.;database=MyDb;Trusted_connection=true;pooling=true;MultipleActiveResultSets=True" providerName="System.Data.SqlClient" />

 </connectionStrings>


I hope this will solve your problem.
 
Share this answer
 
Comments
Abhilask kumar 20-Sep-13 2:48am    
thanks for it. i will try.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900