Unless the CD-ROM drive is dead, then most likely either the power plug or the IDE cable came out slightly.

I know sometimes working inside the box, just by moving stuff around, sometimes the IDE cable gets unplugged enough so the system doesn't see it.

Like what Nokia said....check the cables, make sure the BIOS recognizes it.