There is no direct way to detect if a database connection is still alive
lively. The only thing we can do is to execute some SQL commands. If it
works fine, the connection is good. If it doesn't work and return with a
timeout error, it might be the connection problem. Of course, there might
be other reasons. But it hard to tell with many possibilities.
HTH.
Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
[Full-Disclosure] Advanced usage of system() function. ... and call its arguments as a command for shell. ... as we can see we still didnt get what we want (typing exit...Connection closed by foreign host. ... think what we want to execute.... (Full-Disclosure)
Advanced usage of system() function. ... and call its arguments as a command for shell. ... as we can see we still didnt get what we want (typing exit we are ...Connection closed by foreign host. ... think what we want to execute.... (Bugtraq)
Re: ADODB Command memory leak ..._ConnectionPtr conn = NULL; ... // Execute statement.... > My logic is such that the connection to the database is not maintained ...Create/Append command parameters... (microsoft.public.data.ado)
RE: Database connection object in shared variable ... > Let's say due to several reasons I have an ASP.Net application that> has a database access class that stores a database connection in a> shared member: ... > I also undestand that putting database connection object in a shared> variable can lead to problems because access to shared members is not> thread safe. ... > Now...Only two times I had such a "predictable" issue happening and> the exception thrown was "There is already an open DataReader> associated with this Connection which must be closed first.". ... > I tried to programmatically replicate this by either running calling> multiple pages that will execute a stored procedure containing a> WAITFOR command or that execute a stored procedure that returns> thousands of records. ... (microsoft.public.dotnet.framework.aspnet)
Re: Script Controlled Dynamic Task Execution ... My package had three connections to three ... and each had a transformation for itself. ... After posting, I just created three packages for each connection, and my ... >> need to execute one transformation on a text file, ... (microsoft.public.sqlserver.dts)
