Article ID: 248158
Article Last Modified on 11/14/2003
APPLIES TO
- Microsoft SQL Server 7.0 Standard Edition, when used with:
- Microsoft Windows NT 4.0
- Microsoft SQL Server 2000 Standard Edition
This article was previously published under Q248158
SYMPTOMS
Performing a select statement on a database that exists on a CD-ROM disc may return the following error:
CAUSE
This problem is caused by a known bug in Windows NT 4.0.
WORKAROUND
Share the CD-ROM drive, map a drive letter to that shared drive, and read the data from the mapped drive instead of directly reading it from the CD-ROM drive.
Note that if you share the CD-ROM drive and then connect to this share, you will really be accessing the data on the drive through a normal file system driver (FAT or NTFS) rather than directly to CDFS. Since the problem only exists when trying to do READFILESCATTER on a CDFS file system, this option is a viable workaround.
MORE INFORMATION
For further information regarding this problem, including instructions on obtaining a hotfix, see the following Knowledge Base article:
244145 READFILESCATTER Operation Not Supported by CDFS File System
Keywords: kbprb KB248158