Microsoft KB Archive/101728

FIX: Incorrect Error Message if Device Unavailable

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

4.20

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.