It's probable that either your CD-ROM drive has died or perhaps the
connection is loose. If you are comfortable doing so, open up your computer
and check the connection between the CD-ROM and the motherboard, making sure
the cable is seated properly at both ends. Then try again to see if it is
seen by your BIOS and Device Manager. If not, the drive is probably dead.
Buy a new one.
Badger