Make sure it is booting from the CD.
Check the BIOS. You may have to change the boot order.
Do as Quantos said and check the jumper. If there is no other disk, then use master and not cable select.
You may also want to use another Live CD such as knoppix 5.x or a bsd such as jibbed or bsdanywhere.
Some distributions will occasionally have trouble detecting drives.