Hye,
You will have to check the cables connection which connects from your motherboard to your CD ROM!
Just open the case and then remove the cable and place it again!
Start your pc and go to the BIOS by pressing DEL or F2!
Just try to see if your computer detects your CD ROM!
If nothing happens, you will have to replace the cable to new one!