Hi mafia and welcome to TSF
Do this if you haven't already tried:
start button->run
type in "diskmgmt.msc" (without quotes)
see if your CD drive is listed there below the hard disk partition diagram. If it's there, you probably just have to assign a drive letter to it. Right click it -> add drive letter
If it's not listed there, then a connection to the drive might be loose. Please check all the connection.
Post back your findings.