Detect Dropped Network

[markphsd]

How would i detect if the database connection has been dropped. would i use a network or tcpip connection instead? The time out feature on ADODB connections doesn't seem to work as expected.

Basically I would like to know very quickly if the connection is broken.

Thank you

Mark P.

http://www.cafecartel.com

Providing Low Cost Powerful Point of Sale Solutions.

 

[BobRodes]

I'm assuming that you are automatically trying to reconnect, and want to time out and raise a flag or whatever when you can't. If so, this thread may be of some interest:

http://www.eggheadcafe.com/software/aspnet/31241641/ado-connectiontimeout-tak.aspx

 

[markphsd]

While that may be interesting, I couldn't figure out how it could answer my question.

But yes this is true: "want to time out and raise a flag or whatever when you can't"

thanks

Mark P.

http://www.cafecartel.com

Providing Low Cost Powerful Point of Sale Solutions.

 

[BobRodes]

<I couldn't figure out how it could answer my question.

Perhaps the answer is that there isn't enough control over the environment to which you're connecting to be able to make an accurate determination of when that connection is broken. If there were, then everyone would be doing it, wouldn't they?