Solved

db library dead - connection broken

Posted on 1998-03-29
2
355 Views
Last Modified: 2008-02-01
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
0
Comment
Question by:sarika
2 Comments
 
LVL 7

Expert Comment

by:spiridonov
ID: 1090914


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
 
LVL 1

Accepted Solution

by:
chacko earned 20 total points
ID: 1090915
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

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
sql 2014,  lock limit 5 32
Help Required 3 96
[SQL server / powershell] bulk delete table from CSV 8 33
Sql server, import complete table, using vb.net 9 34
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question