How to check if the connection to a remote computer exist

[Chin Chien Ping]

Hi,

I looking for a solution for how to check if a connection to a remote
computer exist or not using vb.net.

I 'm writing a program which will request data from a remote sql server. I
need to check if the connection to the remote server exist, before open the
connection or run the the sql command.

Pls helps, urgent.

Thanks,
Chin

[Hayato Iriumi]

Hello Chin,

I'd try to open the connection. If exception occurs, that means the connection
to the SQL Server can't be established.

Hi,

I looking for a solution for how to check if a connection to a remote
computer exist or not using vb.net.

I 'm writing a program which will request data from a remote sql
server. I need to check if the connection to the remote server exist,
before open the connection or run the the sql command.

Pls helps, urgent.

Thanks,
Chin

[Chin Chien Ping]

I have tried this method.

However, this will coz my system hang, and I only knew the connection does
not exist until the connection timeout.

Is there any better solution ?

Thanks,
Chin
"Hayato Iriumi" <hi*****@hotmail.com> wrote in message
news:49*********************@news.microsoft.com...

Hello Chin,

I'd try to open the connection. If exception occurs, that means the
connection to the SQL Server can't be established.

Hi,

I looking for a solution for how to check if a connection to a remote
computer exist or not using vb.net.

I 'm writing a program which will request data from a remote sql
server. I need to check if the connection to the remote server exist,
before open the connection or run the the sql command.

Pls helps, urgent.

Thanks,
Chin

[Hayato Iriumi]

I really don't think there is any other solution. When you say "system
hang", does that mean your UI hangs? If that's the case, I'd spawn off a
thread to let it do check connection checking and let it raise an event
to see if the connection succeeded or not. That way, your UI won't hang.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!