could be the cable, the drive, or maybe even a p/s not gettin enough power to the new drive. I doubt the latter there, but that depends on your entire system. I doubt it's the controller if the other CD-Rom works without a hitch. (I know this sounds stupid but make sure pin 1 is oriented correctly). Try a new IDE cable if you can. You might try clearing the CMOS.. I've seen some motherboards with bioses that'll save data on IDE devices and not release it even with new devices installed and detected without clearing the CMOS (do this only if you are comfortable setting up your bios config from it's defaults). The last one is a last ditch effort before taking it back.
***Hey I run Intel... but let's get real***