I had the same trouble that you were having. I had two cd-rom drives(one CD-RW and one 32X CDrom) on one cable.
No reformatting of hard drives or any other means worked in getting my computer to recognize my cd-RW drive worked.
I finally switched the IDE used for my CD drive with the one used for my hard drive. It worked. The only possible conclusion is that I had a faulty IDE cord.
You can get a new one at Bestbuy or any other computer retailer. I always have a few good ones laying around just in case.