V
Verena Doll
I have a PocketPC application written in VB.net which is having
difficutly with the SQLConnection.Open command. When the connection
string is correct, the connection goes through quickly. However, when
the connection string is incorrect, it can take the command in excess
of 60 seconds to return an exception to tell me it can't find the SQL
server. I have tried setting the Connection timeout to 0, 1, 2, 10,
etc seconds, and none of them seem to make any difference.
Does anyone know a way to shorten the time it SQLConnection.Open will
try to connect, or to force it to end early? The application running
is time-critical and any conenction that locks up acticity beyond 5
seconds is to long.
Thank you in advance for any suggestions.
Verena
difficutly with the SQLConnection.Open command. When the connection
string is correct, the connection goes through quickly. However, when
the connection string is incorrect, it can take the command in excess
of 60 seconds to return an exception to tell me it can't find the SQL
server. I have tried setting the Connection timeout to 0, 1, 2, 10,
etc seconds, and none of them seem to make any difference.
Does anyone know a way to shorten the time it SQLConnection.Open will
try to connect, or to force it to end early? The application running
is time-critical and any conenction that locks up acticity beyond 5
seconds is to long.
Thank you in advance for any suggestions.
Verena