db library dead - connection broken

The major problem I am facing now is while executing some SQL Queries
ODBC driver throws an exception saying "Protocol
error
in TDS stream". After that the application looses connection with the
database.
But some times these queries get executed successfully (which means there
is no
problem in the syntax)

When I ran the same queries through ISQLW, there also some times the query
gets executed but not always. When it fails in ISQLW, it gives a message
"DB-Library Process Dead - Connection broken"

The common thing in all these queries is that some of the objects being
accessed by these queries are VIEWs.

Is this a known bug in sql serve 6.5?

Thanx in advance
sarikaAsked:
Who is Participating?
 
chackoConnect With a Mentor Commented:
Hi Sarika!

ODBC often loses it's connection because of the timeout. You can use ODBC functions to set the login and query timeout value. The latest ODBC driver 3.0 and SQL driver are available from Microsoft free in microsoft.com.

Bye,
chacko

0
 
Victor SpiridonovCommented:


What client software are you using? Try applying service pack #3 or #4 to your client workstation. If you using 16-bit odbc, manualy  copy the necessary dll's from SP#3/SP#4 to you windows\system directory

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.