Hi guys,

How do I check the real state of my ADP connection to the database?

i.e. Supposed I am connected to the Database now. But due to some network problem, I am disconnected while I am running some process. I want to be able to tell that this connection is lost/broken.

Currentproject.Connection.State And Currentproject.Isconnected does not seem to work here as they will always return true if I have previously established the connection before the network problem.

Thanks in advance!


Scripts82

__________________
Scripts82

Can't you run a second process to return a simple value, and if the value (recordset) is empty, then you can deduce you have lost the connection? (If you run it on the same connection) I admit, it is a kludge, but it monitors the connection nevertheless. Run the sample before your process, and if the recordset = 0, then reestablish the connection.

HTH


mmcdonal

Hi mmcdonal, thanks for the help.

I get what you mean. In fact, I have a timer event that attempts to connect to a recordset and will prompt me when connection is lost.

The problem is, when I am scrolling through an ADO recordset and using on error resume next.

------------------------------------------------------
For example:

On error resume next
Do while not rs.eof
    debug.print rs![Column1]
    rs.movenext <-- connection gets disconnected here
loop
------------------------------------------------------

In the above situation, I will go into an endless loop. The timer does not have a chance to be "activated".
Of course I can choose not to use "On Error Resume Next",
but is there any other way to detect connection status cause otherwise, I will need to make quite a bit of changes to the program.




Scripts82

Hi everyone,
Managed to solve the problem with a a for loop with DoEvents... this way, my timer will have a chance to be invoked and prompt the user to reconnect.

Thanks anyway

Scripts82