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?
That's really 2 questions:how can this be prevented - without reconnecting the handle?
That, I don't know. Maybe the MS site for more info? SysAdmin for their network?how can [the connection breaks down] be prevented?
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.without reconnecting the handle?
Maybe someone else has something more encouraging, Klaus.
Who is online
Users browsing this forum: [Ccbot] and 4 guests