As you have checked for connections being correct, go to the My Computer icon on the Desktop>right click>Properties>Hardware>Device Manager.
From DVD/CD drives, click the Plus sign (if you have more than one drive), highlight your rewriter drive and click Properties.
From the General tab ensure that Use This Device (Enable) is listed. If so, Cancel the panel, click on Uninstall in the list and then reboot.
Hopefully Windows will find Add New Hardware and your rewriter and the basic Windows CDROM driver will be reinstalled.
If this doesn't work then it could just be that your rewriter's laser has given up the ghost. If so you can buy new CD-RW rewriters for around £15 and, even better, a top brand DVD version for about double that.