If it is not showing in BIOS/CMOS then there is no way it will show up in Device Manager.
What type of CD/DVD drive is it? Is it a PATA or SATA? The difference is that PATA uses the wide ribbon cables and SATA uses the narrow smaller cables, in a nut shell.
First open the computer (unplug it first and touch the metal chassis with your hand to discharge any present static electricity) and be sure the drive cable is secured to the drive and motherboard. And be sure power cables are connected. If all is good there, keep this in mind...
If the CD/DVD drive is PATA, and it has more than one drive attached to the ribbon cable, be sure the CD/DVD drive has the correct jumper setting. Usually the CD/DVD drive receives the "slave" setting and the Harddrive receives the "master" setting.
If the CD/DVD drive is the only drive attached to the cable then the drive should be set to MASTER or "Cable Select".
Once you get the drive to show up in CMOS then it will likely show up in device manager....let me know what the outcome is