Communication Link Failure error

Hi Y'all,

When i alter 1 single value in my sql server 2000 sometimes i get following error:

1) [MICROSOFT][ODBC SQL SERVER DRIVER] Communication link failure

After clicking away:

2)CANNOT START MORE TRANSACTION ON THIS SESSION

Maybe someone can help me out on this?

Thanks!

Hi,

First, make sure that your largest column is the last column retuned. Make sure that you do not have any columns returned after a text or an image column

Second, have you recently finished any kind of an upgrade that may have impacted the MDAC? The default connection protocol in MDAC 2.5 was Named Pipes. In 2.7, it changed the default to TCP/IP. You mentioned that you are connecting via TCP/IP, but can you verify that in EM?

Third, you may try the following article which may be helpful to you.http://support.microsoft.com/kb/316872

Hope this helps. Thanks.