October 16, 2007 at 5:32 pm
I have a number of users experiencing "Communications Link Failure". One is the result of a 7105 error with appears to have something to do with rolling back a row with an NTEXT column using READ-UNCOMMITTED isolation level. I can't seem to reproduce it but I've got other users experiencing the same error for other reasons.
I remember in the past using the MSS ODBC driver against MSS 2000, I could monkey with the network library configuration or use an untrusted TCP connection and often end up with a "Communications Link Failure" but I think I need to add registry entries just to get at these libraries with the native 2005 driver as they are unavailable from the DSN configuration menus.
I need to see how our application is dealing with a "Communications Link Failure" error condition so my question is how can I invoke this error during an MSS 2005 session connection. Any ideas ? Can I just find the corresponding message ID in SQL Server and invoke it from a stored procedure ? That seems straight forward but then I may not get the actual link failure action invoked by the database engine. I think the database needs to invoke the error in response to some egregious server anomaly. Then I'll get the corresponding unrecoverable network drop - which I also need.
October 25, 2007 at 9:51 am
Well it's my post but I'm replying to myself in case anyone else needs to know how to duplicate.
Basically, all you need to do is establish a connection to the server and then unplug the network cable for quick second then plug it back in. This produces a 'Communication Link Failure'. Since this is burning our application at the moment, it might behoove others to examine their application and see how well it holds up to such an abrupt disconnect.
October 25, 2007 at 9:38 pm
Beat your developers. A simple try/catch/finally can handle just about any error you or I can come up with, if your application is not catching the database disconnect and attempting to reconnect it's nothing but poor coding.
Joe
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply