Your picture only shows one IDE connector, located between a couple of SATA connectors and your first PCI slot. The connector at the very edge of the board on the left side of the picture is the floppy connector.
Your hard drive is connected via SATA---I wonder why it is showing up as if it was on the Primary IDE? But Ultra DMA mode 5 should be correct for a hard drive. Hmm, beyond my experience, as I haven't had to switch to SATA hard drives yet. Have too many good PATA IDE hard drives left, and haven't built a new system in a while.
When you click on My Computer, the dvd drive should be correctly identified there, despite it saying cdrom installed.
Just a thought, do you have the jumper on the back of the drive set to Cable Select? You might try changing to Master and make sure you have it installed in the last connector of your IDE cable. Grasping at straws here I know.