I'm having the same problem, except the disk drive isn't even showing up in device manager. I assumed it was a problem with the disk since Autoplay did nothing, but i've tried several with no luck.
I had my CD/DVD/BluRay writer not showing up the first time, but after rebooting it showed up the next time. I'm not sure what happened.
If you reboot and go into the BIOS (usually F8 or Del), can you see the drive in there? Maybe it just died at the same time coincidentally.
If it doesnt, try connecting it to a different SATA port on the mobo. If you can start your computer and hear the cd drive spin up, then it will likely be detected in bios.
I'm curious. Does it open and close in windows? Does the drive have a physical Open button on it?
It's working! Thanks a lot guys, you've been a great help