Device manager only says the drivers (software) are OK. But that says nothing at all abut the drives (hardware).
Things to try:
1. New drives. If those work it's solved.
2. See if you can boot from a bootable Linux disk (try it on another PC, so you're sure it's bootable). Be sure the BIOS is setup to boot from the disk! If that works, and the drives work inside Linux also, it's a Windows issue. Unlkely, but since it's so easy to test, it's a useful step.
3. If you can't boot any bootable disk from the new drive, or you can boot Linux, but they don't work there, either replace the motherboard or use an external (USB) drive.
Kees
Compaq Presario sr1250nx. Both DVD and CD drivers 'work properly' according to the device manager, and show up under 'My Computer', but when any disc is put into either drive, nothing appears. The computer doesn't seem to 'see' them. They try to run, then stop, the green light blinks, then it shuts off. Everything seems plugged in when I take the side of the computer off. Now what?

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic