Try only connecting the cdrw drive to the IDE cable.
Also try using a different power plug for the drive.
If the BIOS still can't detect it, I think the drive is toast.
You might want to try the drive in another computer (if possible) just to be sure.