I have been using Visual Source Safe 2005 for quite sometime. I came to an unusual problem. I tried opening a project solution created under Visual Studio 2010. When I double clicked the solution, it redirected me to "My Computer" list which contained Physical and Network directories. After quite a bit of searching for answer, I found a solution to this issue. There is a Microsoft patch (KB943847) for VSS 2005 that needs to be applied to the VSS 2005. This solves the issue of redirecting to My computer when trying to open solution on VSS 2005.
This is the error message you will get when pool is maxed out.
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.
Please try closing reader, command, connection by using close() and dispose() before using the method below.
If the pooling is enabled in the application, sometime closing the connection by using Dispose() or Close() is just going to put the connection on the sleep mode (awaiting command). Even though there is connection closing statements on the application, on the database side, it was putting those connections on the sleep mode. As it built up, there were no more pool left, therefore it timed out.
Solution is to add Pooling = False
on the connection string of the application. This closes the connection as soon as dispose() is introduced. Hence no timeouts waiting for open pool.
Database=testdb; Server=testserver; uid=test; PWD=test; Pooling=False; Connect Timeout=30
I am not responsible if you use my solution and mess up something. Do at your own risk. Works for me here.
Checking number of connections on database to see if max pool has reached …
--Total number of connections
SELECT DB_NAME(dbid) AS 'Database Name',
COUNT(dbid) AS 'Total Connections'
FROM sys.sysprocesses WITH (nolock)
WHERE dbid > 0
GROUP BY dbid;
SELECT hostname, program_name, STATUS, cmd FROM sys.sysprocesses
WHERE DB_NAME(dbid) = 'Database Name goes here';
I Googled for the solution and never found one that is simple, short and to the point. Here is the fastest solution to opening a link in a new page if you are using a button or a link button on ASP.NET 2.0/3.5.
Add this attribute to your button. This goes on your page load section of the code.
Unfortunately I could not find a solution using response.redirect