Communication link failure.

What could cause the Microsoft error listed below?
[Microsoft][ODBC SQL Server Driver]Communication link failure.
Thanks,Hi
Loosing connectivity to the server.
In what scenario does this occur?
Normally, network connectivity problems between a server and a client are
caused by faulty network cards, cables and switches. Also check that your
network drivers are up to date.
Regards
Mike
"Joe K." wrote:
> What could cause the Microsoft error listed below?
> [Microsoft][ODBC SQL Server Driver]Communication link failure.
> Thanks,

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.