Solved

SQL Restore problems

Posted on 1997-09-29
3
299 Views
Last Modified: 2008-03-17
On restoring from tape the following error is given

ERROR 10005:[DB_LIBRARY] DB PROCESS IS DEAD OR NOT ENABLED

in short .. HELP! .. this is fairly urgent so a quick response would be appreciated :)

thanks
0
Comment
Question by:british041297
  • 2
3 Comments
 
LVL 9

Accepted Solution

by:
cymbolic earned 400 total points
ID: 1088967
Perhaps the following relate sto your problem.  I noted that it is fixed by the latest service pack update.

Microsoft Knowledge Base

FIX: Win16 DBLIB Does Not Restrict Packet Size to 512 for SPX

Last reviewed: April 8, 1997
Article ID: Q152130 The information in this article applies to:

•Microsoft SQL Server, version 6.5

SYMPTOMS
A DB-Library application for Windows may return the following error when executing a query that returns a large number of rows under IPX/SPX:
   Possible Network Error; Read From SQL Server Failed.
   This command did not return data, and it did not return any rows
   DB-Library Process Dead - Connection Broken

When this occurs, the connection will be lost, and closing the application may cause Windows to stop responding.
CAUSE
The Win16 DB-Library DLL (W3dblib.dll or Msdblib3.dll) does not correctly detect the IPX/SPX Net-Library for Windows. As a result, it does not automatically restrict the TDS packet size to 512 bytes. This causes DB- Library to use the default "Network Packet Size" setting on the server side, which is 4096 bytes by default. Due to the architecture limit in DBMSSPX3.DLL, a larger TDS buffer size is not supported. Attempting to use a larger TDS packet size can cause unexpected errors or make the system otherwise unstable.

WORKAROUND
You can work around this problem either by forcing the packet size to 512 through the DBSETLPACKET() DBLIB function or by reducing the default "Network Packet Size" on the server side to 512 bytes.

STATUS
Microsoft has confirmed this to be a problem in SQL Server version 6.5. This problem has been corrected in the latest U.S. Service Pack for SQL Server version 6.5. For information on obtaining the Service Pack, query on the following word in the Microsoft Knowledge Base (without the spaces):
0
 
LVL 9

Expert Comment

by:cymbolic
ID: 1088968
P.S. I noted two other DBLIB process dead fixes in the detail of that serveice pack as well.
0
 
LVL 1

Author Comment

by:british041297
ID: 1088969
Thanks .. we actually found that Service Pack 2 or greater solved the problem.

Thanks for your prompt and helpful response

BRiTiSH
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Union 20 44
SQL Server Deadlocks 12 47
SQL Server - SQL field is defined as text 3 27
Sql Count with Select Distinct 4 26
When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
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…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

932 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

11 Experts available now in Live!

Get 1:1 Help Now