Solved

SQL Restore problems

Posted on 1997-09-29
3
305 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

829 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