Sorry to say it, but to date the typical outcome of this problem has proven to be a hardware fault in the drive :sad:. Most likely the OPU.
When you say "It also didn't recognize the bootable CD", was this at boot up, by the BIOS. If so, then it is a fault with the drive. If not, try this to be sure.