sql server connect: Hi,

we have written a vb.net program using SQL Server 2000 SP4 over OLEDB.
Our customer has a network which is sometimes quite instable. So we did
some tests in our office, because we wanted to help our customer by
redisigning some of our SQL calls.

When we start the program and disconnect the network cable then the
next SQL query will result in a General Network Error, which is
logical.

When we start the program, then disconnect the network cable for about
ten seconds, then reconnect it, then the next SQL query will also
result in the same error, which we already cannot understand.

When we do the same as above, but before the next SQL query we close
the connection and reopen it, we still get the same error, which is
strange.

When we close, dispose and then recreate and open the connection, then
assign the connection to a new command and execute the SQL command, we
still get the same error.

When we stop the program and restart it, we can reconnect to the
database.

But when starting the program, we do nothing else than creating and
opening a connection. So why does it not work to reconnect while the
program is running?

Any explanations or suggestions?

Many thanks.
Daniel.

Dear Daniel,
I got the same error with u , Did u solve the problem?

thanks
From Agnes

Hi Agnes,

Unfortunately I never have got an answer to this post. I also posted
similar requests to other forums, but I never have got any answer. So
our problem still persists.

Regards.
Daniel.