Hi friends, I have created an asmx web service in which it has one database and some tables in it. Every thing is works fine when I tested through my visual studio development server. but when I hosted the service in IIS 7.0 I am un able to get the data so I thought to use try catch statements and caught the follwoing error.
but I was unable to find what is the error and how to solve it.
Below is my error,
System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at InventoryWebService.AgencyManager.GetAgency(Int32 AgencyId) in E:\InventoryWebService\InventoryWebService\DAL\AgencyManager.vb:line 19
Please any one tell me what may be the error.
Thanks in Advance