In the instance when your cd drive is not detected in Windows explorer and Device manager, try disk management to check for the drive.
Hit Start and type disk management on Search programs and files box, Enter. Your hard drive will be reported as C:(drive) and optical drive as CD-ROM 0(DVD, either D:, E: or F:). Is it also not shown? You could also restart PC, then tap F2 to check on your BIOS utility setup. The information will display also your Hard drive description(Hard drive model name) and optical drive (or ATAPI model name) for your CD drive. Is it also there or not? Do this when CD Drive is not shown as you posted and mentioned above. This is a rare case actually about your drive connected to power adapter or battery being low would cause that effect.