472,102 Members | 1,540 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,102 software developers and data experts.

wrong return value: connection state "open" when it is actually "broken"

ITP
Hello,

I'm seeing this with the ADO.NET SQLClient provider:

When I check the connection's open status after it has
been opened AND has been broken (I simulate this by
disconnecting the cable or by stopping SQL Server), the
status returned is "true" or that it is open. The
connection status of "broken" is not currently supported
and therefore does not work either.

Have anyone else found a way around this?

Regards,

ITP
Nov 20 '05 #1
3 2173
Cor
Hi ITP,

I saw your message somewhere else, I don't have an answer, but this has to
do with a vb.net language event that is not fired i saw.

I write this because you otherwise probably get a long thread telling you
that there is a better group for this.

Cor
Nov 20 '05 #2
* "Cor" <no*@non.com> scripsit:
I saw your message somewhere else, I don't have an answer, but this has to
do with a vb.net language event that is not fired i saw.


Why? Doesn't the problem occur in C# too?

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
<http://www.mvps.org/dotnet>
Nov 20 '05 #3
Cor
Herfried,
Is that so, because maybe the OP is curious if it is only in vb.net?
Cor
Nov 20 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Lars Schlanbusch | last post: by
205 posts views Thread by Jeremy Siek | last post: by
94 posts views Thread by Samuel R. Neff | last post: by
8 posts views Thread by Steven D'Aprano | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.