Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/101728

From BetaArchive Wiki

FIX: Incorrect Error Message if Device Unavailable

PSS ID Number: Q101728 Article last modified on 10-31-1994



The information in this article applies to:
- Microsoft SQL Server version 4.2 for OS/2

BUG# OS/2: 1641 (4.2)


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.


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.


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.