Hmm this could be a wide range of problems. I would start with the basics. I know it sounds dumb, but go back through and verify that power and bus lines are plugged into the devices and showing up in the BIOS like VirtualRanger was saying. If that confirms we will move on to trouble shooting the kernel.
dmesg|grep -i cd
look around through these messages and see if your CD rom device was even detected if not there may be a bus module that isn't getting loaded.
let me know what you find.