FIX: Incorrect Error Message if Device Unavailable
  
PSS ID Number: Q101728
Article last modified on 10-31-1994
 
4.20
 
OS/2
 

----------------------------------------------------------------------
The information in this article applies to:
 
  - Microsoft SQL Server version 4.2 for OS/2
----------------------------------------------------------------------
 
BUG# OS/2: 1641 (4.2)
 
SYMPTOMS
========
 
If a database device is not available to SQL Server during startup,
SQL Server should issue error 840:
 
   Device '%. *s' (with physical name '%. *s', and virtual device number
   %d) has not been correctly activated at startup time. Please contact
   the System Administrator.
 
Instead SQL Server issues error 822:
 
   Could not start I/O for request %S_BLKIOPTR.
 
CAUSE
=====
 
This condition usually occurs if the device's .DAT file is deleted
while SQL Server is not running. If the .DAT file resides on a network
file server, it may occur if the SQL Server server loses its
connection to the file server.
 
STATUS
======
 
Microsoft has confirmed this to be a problem in SQL Server versions
4.2 and 4.2a for OS/2. This problem was corrected in SQL Server version
4.2aK10. For more information, contact your primary support provider.
 
Additional reference words: 4.20 Error Log
KBCategory: kbother kberrmsg
KBSubcategory: SSrvServer
 
=============================================================================
 
Copyright Microsoft Corporation 1994.
