try uninstalling the drive in Device Manager, ie: right click, left click uninstall. Reboot the machine. Windows will automatically reinstall it.
You should only have the drive jumpered as Cable Select if your other drives uses the same jumper scheme. ie: if your hard drive is jumpered as Cable select then the optical drive should match. If the hard drive is jumpered as Master then the optical drive should match it (if it's the only drive connected to the secondary ide port.) If you have 2 optical drives then they will need to be jumpered accordingly, ie: if hard drives are Cable Select then all optical drives should be Cable Select but if hard drive is set to Master, then optical drives should be the same.
Is this drive by chance a SATA drive?