Booting to KNOPPIX always works for me, since I tend to have a cd lying around. It's autodetect is really, really good. Plus, it's super convinient to have around anyway, so you should probably go ahead and download it if you can.
for the uninitiated: KNOPPIX is a stand-alone linux distrobution that you can boot to from a CD. It's non-volitle, and won't hurt your windows install, and to get rid of it all you do is reboot and take out the CD. (Actually, I think they're up to a DVD version now too, but that's a moot point).
Come to think of it though, device manager picked up my cd-rw with no problems, just as it should. If there are no yellow "!"'s in the device manager, then chances are it's actually hooked up wrong. If windows can't identify it, it should at least come up as a generic cd-rom. Check your cables, and check to make sure all the jumpers are set to Cable Select (or master/slave if you know how).