right click on the DVDdrive in device manager
and select REMOVE.
Reboot, and let windows re-detect new hardware.
when it asks for driver location, point to
system32\drivers (or equivalent) and see what
happens.
barring actual hardware failure, its most likely
a rogue driver that got displaced or corrupted.
This morning My Computer stopped showing the DVD/CD drive, only the HD is listed. I opened up Device Manager and the drive has a yellow hazard/exclamation point sign next to it. The properties menu gives this explanation:
''Windows cannot load the device driver for this hardware. The driver may be corrupted or missing. (Code 39)
Click Troubleshoot to start the troubleshooter for this device.''
Troubleshooting told me to try uninstalling the drive then reinstalling, then to check for an update driver. I tried both, Windows could not find an updated driver for it. I believe its a Hitachi drive, it doesnt show in System Information and theres no writing from what I can see when I eject the tray.
Not sure where to go from here, any help would be great.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic