How to avoid this hanging method?

[georgepatotk]

               conn = New MySql.Data.MySqlClient.MySqlConnection(ReadConnectionString)
               If conn.State = ConnectionState.Closed Then
                   conn.Open()
               End If

 

This code is working when the ConnectionString is correct with the server is detected.

 

But, if the server is unavailable, the process/winform will hang over here for a very long time. Do u have any idea on how this happen? and how to avoid this from being happen? Cause when the server is down, customers would be very mad already, and if they see this thing hanging, I think I would gain some bullets from them...

 

Please comment...

[snarfblam]

Multithreading. See similar question.