Connection to SqlServer

[klaushaidinger]

Hi,

depending on the network-infrastructure of our customers (basically LAN), we are somtimes
faced with low quality connections (bad wlan, mobile broadband, ...). if we connect to
the database (sql server 2005 express) and the connection breaks down for 5, 10 or more seconds,
the handle seems to be invalid.

how can this be prevented - without reconnecting the handle?

thank you!
klaus

[Jeff Luther]

how can this be prevented - without reconnecting the handle?

That's really 2 questions:

how can [the connection breaks down] be prevented?

That, I don't know. Maybe the MS site for more info? SysAdmin for their network?

without reconnecting the handle?

I don't think you can without a reconnect. If the Sql Handle connection becomes invalid (because the connection got dropped) then the Sql Handle needs to be reconnected and presumably any outstanding transaction is rolled back/committed?, depending on how MS Ex. works.

Maybe someone else has something more encouraging, Klaus.

[jmcnamara]

Some code samples to reconnect after network breakage have been posted in other threads. The solution is tricking and not alwasy reliable.

IMHO, If you qoute your client(s) a high enough price, maybe they will do the right thing and fix their networks.