Unanswered: Connection timeout while connecting to postgresql8.4
We have a web based application developed using asp.net 2.0 and back end postgresql 8.4 We are using npgsql 1.0 as provider. But very frquently for very few users 3,4 we star getiing the error connection timeout while trying to obtain a connection from the connection pool. We have closed all connections after use in the application (connection.close()). But not disposed the connections. Please help to solve this problem.
For all data access we have separate classes written in which connection is defined, opened, used, closed. Whenever data access is rewuired an instance of this class is created and the required methods are called to perform database operations like select, insert ...
Please help to solve the connection timeout problem