Windows 7: DVD/CD-ROM drive not working (Code 10 or 59)

Problem:
DVD/CD-ROM drive not working (Code 10 or 59) on Windows 7
A yellow exclamation mark remains on DVD-ROM in Device Manager after reinstalling and rebooting as well.

Soulution:
Run "regedit"
Search key:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Class\{4D36E965-E325-11CE-BFC1-08002BE10318}
Mark it.
On the right pane delete "Upperfilters" and "Lowerfilters" values.
Close "regedit"

Open "Device Manager"(eg. run/devmgmt.msc).
Search "DVD/CDROM Drives".
Click on DVD/CD-ROM, right click and "Uninstall".
Restart the computer.

Source: 
Microsoft TechNet