*note: i think this should go to hardware problems.

but to your problem: have you checked that the IDE device has been enabled in your BIOS? you can reach the bios menu my holding in F2 (or whichever key it prompts you to to enter 'setup') when the computer boots up. This will bring up the system BIOS menu. i guess in laymans terms it's a bunch of settings that your computer uses when it starts up to find stuff, set hardware states, etc. after a bit of shuffling about (don't change anything, if you do, follow the instructions to not save your changes) you should find 'CD-ROM IDE devices or something like that. set that to 'automatic' and save and exit. the computer will reboot on its own, and it 'should' automatically detect your cd/dvd rom drive.

If that doesn't work, double check that the physical connections on both ends are secure, that the power works on the drive, and that the cable isn't damaged.

if all those things check out, and windows still won't recognize it, put your windows recovery disk in, and reboot your computer, holding F12 (again, this is only for most, see what it prompts for 'boot devices' or 'boot order' on the first screen you see) and that will bring you to the boot menu. select the option to boot from IDE CD-ROM device. If that doesn't work, there might be something wrong with the drive, but if it doesn't work with either, it might be a jerky setting in your BIOS.

Hope that helps. Just remember to explore BIOS fully, but be careful what you change.