I think I can help you with this problem, because I had same one a week ago. My cd-rom stopped working after I blew the dust away from my comp case. I checked all the cables - nothing... used cleaning disk - nothing... opened up the cd-rom case to examine the lense - I just managed to destroy fully working device (as I discovered later)... So I put into another cd-rom device and that did not work either... at that place my ideas were over - I even thought, that motherboard was somehow corrupted and could not support cd-rom anymore...
Uninstalling and reinstalling did not help at all.
Then friend of mine advised to use disc bootable linux to ispect, if the cd-rom was ok. I used Knoppix 3.9, which can run on NTFS (just set your bios first boot device to cd-rom, insert disc and restart your comp.) Knoppix recognised my cd-rom instantly and booted up. After that all there was to do was to reinstall windows. With new windows my cd-rom worked again.
PS: do your usb ports work? When I had problems with my cd-rom, the usb ports did not work either.