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

 

[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

 

[Herfried K. Wagner [MVP]]

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?

 

[Cor]

Herfried,
Is that so, because maybe the OP is curious if it is only in vb.net?
Cor