I understand the issue, that the CD\DVD drive is not recognized in windows explorer and also CD\DVD drive is detected in BIOS.
I would suggest you to follow these steps and check if it helps.
a) Right click on the Left Bottom Corner (Start Menu).
b) Run Command Prompt as an Administrator.
c) Type cmd in Windows 8 Metro UI and press cltr+shift+enter.
d) Type following and say enter
reg.exe add "HKLM\System\CurrentControlSet\Services\atapi\Controller0" /f /v EnumDevice1 /t REG_DWORD /d 0x00000001
e) Reboot the system.
f) Verify if the problem has been resolved.
If the issue persists run hardware and troubleshooter and check.
a) Press “Windows Key + R”, type Control Panel.
b) Then type “Troubleshooter” in the Search box and hit enter.
c) Select “Hardware and Sound” from the Troubleshooter Window.
d) Select “Hardware and Devices”.
If the issue persists I would suggest you to follow these steps, uninstall and re-install the CD/DVD ROM drivers in compatibility mode and check if it helps.
Note: Download the drivers from the Manufacturer’s website and install it.
a) Press Windows Key + R, type devmgmt.msc.
b) Expand the CD/DVD ROM drivers, click on the drivers.
c) Click on properties, click on uninstall tab.
d) Click OK.
e) Right-click on the driver executable/installer file.
f) Click on Properties and select the Compatibility tab.
g) Click the checkbox before Run this program in Compatibility mode for option and select Windows 7.
h) In the list-down box; then try installing the device driver via Run as administrator.
Hope this helps.. !!!