|Even unfamiliar hardware would show in device manager but with a remark that there is some problem with it, such as drivers not installed.|
You indicated above that the bios isn't seeing the drive. That's where the problem is--not with windows. Either the drive is bad, there's something wrong with the connection or it's improperly configured in cmos/bios setup. If the motherboard has SATA support you need to verify that whichever type the DVD drive is, it's enabled.
But you say you have another DVD-RW drive that works. I assume you mean it works in that PC. If so, the other one must be bad.