Why do people find this board so confusing :P
Next to the red connector there are two black connectors. These are SATA/300 connectors on the ICH7R southbridge and support any HDD or Optical drive fine.
The two orange connectors to the left in that picture, are on a Silicon Image RAID controller. This is for running RAID1, RAID0, or JBOD on two drives. No drivers are required for this, (no F6 on windows install crap) but they are limited to SATA/150, as this controller is interfaced via the missing SATA/300 connector from the ICH7R.
This is in practice no limitation tho, no hard disk can challenge the limits of SATA/150 anyway, hell Raptors don't even support SATA/300. The advantage gained by offloading the CPU load to the Silicon Image controller outweighs the loss due to SATA/150 many times over.
The final SATA/300 port is from the Jmicron controller, and is in black between the WLAN module and the audio output jacks.
This has the advantage of being seen by Windows as SCSI, and so is very useful if you have an SATA DVD±RW drive and are having issues with StarForce.....
There is also an eSATA port on the back panel.
The two PATA channels support up to 2 drives each, giving an upper limit of 11 drives without adding other controllers or using port multipliers.