1) Does the BIOS recognize the CD-ROM drive during POST. If yes...
2) Do you have DOS drivers that load for the CD-ROM drive. If yes...
3) Reboot the machine in MS-DOS mode, and change the drive letter to the apropriate letter of the CD-ROM drive and type DIR to see if it will give you a directory listing.
If the BIOS on the machine does not recognize the CD-ROM during power up. Check the drives power cable and data cable. If these are secure and connected correctly then the drive is mostlike defunct.
If you do not have drivers then go to the Control Panel (start >settings >control panel) Double click the Add/Remove programs icon. Click the start up disk tab and make a start up disk. This should load DOS CD-ROM drivers on a 3.5" diskette. Use this diskette to boot the computer and again change the drive letter and check to see if it will give you a directory listing.
If you get a directory listing in DOS, there isn't any reason that I can think of that you can't read a CD-ROM in Windows. You may have a virus, or some sort of IRQ conflict.
Hope this helps.
Chris