DBException (Communication link failure)

Hi,
with SQL 2000 and Windows 2000, we're getting lots of this error message
"Communication link failure" from our C++ application.
Any idea why?

Thanks,neo (second714@.hotmail.com) writes:
> with SQL 2000 and Windows 2000, we're getting lots of this error message
> "Communication link failure" from our C++ application.
> Any idea why?

There are many possibilities.

One is of course that you have a network problem.

Another is that you have some SQL code that cause the SQL Server process
for the connection to crash - access violation, stack overflow - in which
case SQL Server closes the connection quite brutally. In this case, the
SQL Server error log will include a stack dump, which in time is correlated
with the application being disconnected. Such a crash, by the way, is due
to bugs in SQL Server, not in your SQL code.

There are probably several other reasons, but with the miniscule of
information you have posted, I stop here.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Thanks for your reply.
We have two SQL server machines both with problems.
one with Windows 2000 SP3 and SQL 2000 SP3
another one with XP and SQL 2000 SP3
We'll get the latest OS SP for both machines
and have to wait a couple of date to get IT.

I didn't want to put this information before
because I wanted to get all the possible answers.

we'll see after OS update and if it's not fixed,
then I'll come back to this news group.

Thanks a lot,