Solved

db library dead - connection broken

Posted on 1998-03-29
2
346 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
Comment Utility


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
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

772 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now