If no hard drives are bootable, BIOS will next look for bootable media in the CD-ROM drive, next for bootable media that's attached (like a flash drive), and finally, it will look on the network.The BIOS is able to detect the DVD drive though. I have tried upgrading the BIOS as well and it can't seem to work either. I've also tried different cables to no avail. I have two HDDs and I've tried both and both can't be detected. But as I'm trying to install Windows 7, it seems like the BIOS can't find the hard drive.
If the drive still isn't showing up and all the connections are secure, try plugging the SATA data cable into a different.