neo (se*******@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,
so****@algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp