The first thing you should try is the microsoft fixit for that problem. Click my link and then when the fixit page opens up, you should see a green button that says "Run Now." It has to install or enables Windows powershell and WIndows MSXML 6.0 in order to run. They've recently changed the fixit layout. It USED to give you the instructions if you wanted to do it manually along with the automated fixit option.
AH, I found the one that gives you the manual option as well: KB 982116
EDIT: I didn't read your post closely enough the first time. Sorry. You aren't showing up in BIOS. I'd try the fixit just for grins, but I think Mr.Bruce has it nailed. Sounds like your optical drive has given up the ghost and is dead.
Edited by DeathStalker, 11 April 2010 - 09:06 AM.