Right, well you have two sets of SATA ports, one set of six is controlled via the ICH10R Southbridge controller and the GSATA controlled ports of which there are two.
I would suggest setting the GSATA controller to IDE and the Southbridge to AHCI and you should be sorted.
Sorry can't say about the addon card.
From the manual:
South Bridge: 0.6 x SATA 3Gb/s connectors (SATA2_0, SATA2_1, SATA2_2, SATA2_3, SATA2_4, SATA2_5) supporting up to 6 SATA 3Gb/s devices
0.Support for SATA RAID 0, RAID 1, RAID 5, and RAID 10
GIGABYTE SATA2 chip: 0.1 x IDE connector supporting ATA-133/100/66/33 and up to 2 IDE devices
0.2x SATA 3Gb/s connectors (GSATA2_0, GSATA2_1) supporting up to 2 SATA 3Gb/s devices