Determine connection state to enable offline capabilities

[Rubbrecht Philippe]

Hi there,

I developed an application that reeds configuration settings from a central
database.
Whenever the dataset is read, it's also saved as a local XML file on the
machine.
Whenever the central server is unavailable, the local file is used to enable
offline working.

I would like to now what the fastest method is to determine connection
state.
Trying to open the database connection and waiting for the exception to be
thrown does not seem to be the best way?!

Maybe pinging the central server could be faster and better?!
But how can I do that from Visual Basic .NET?

Can anybody help me out?!

Best regards, Philippe

 

[Ken Tucker [MVP]]

Hi,

http://msdn.microsoft.com/library/d...ry/en-us/dndotnet/html/northwindunplugged.asp

Ken
---------------------
message Hi there,

I developed an application that reeds configuration settings from a central
database.
Whenever the dataset is read, it's also saved as a local XML file on the
machine.
Whenever the central server is unavailable, the local file is used to enable
offline working.

I would like to now what the fastest method is to determine connection
state.
Trying to open the database connection and waiting for the exception to be
thrown does not seem to be the best way?!

Maybe pinging the central server could be faster and better?!
But how can I do that from Visual Basic .NET?

Can anybody help me out?!

Best regards, Philippe