Microsoft KB Archive/101728

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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.