ASUS P8Z77-V Problem. Finds hard drive, but not DVD-ROM

If you are absolutely sure that the optical drive is connected properly, try a different optical drive if you can lay your hands on one, even a plain old cd drive, just for troubleshooting purposes. That will help to establish whether or not your optical drive is internally faulty.