Sorry, I answer so late!
I have a RAID card, too (if you got the green one I posted, it is, too), I do not have jumpers set for RAID and use it normally. I don't remember, if I used the RAID driver.
I will later upload the driver I have on my HDD, so you can use the same!
First look, if you have to put jumpers on the little needles that show up next to the slot cover.
Do you have at least 10.4.
11 or 10.5.8 installed?
I just plugged a power connector to the drive and the SATA cable from the drive to any port, no matter what port, all will see the drive.
If you have other PCI card in, put them out.
Delete the driver just installed.
Put in the new card.
install the driver (without drives conected). The driver must be on your boot drive.
shut down Mac.
boot Mac.
shut down Mac.
Open door and connect drive. Restart, wait a few second, now does a an orange symbol (like, when you have an external drive connected) appear?
Remember you can see the drive and read and write to it, but not boot from it.
Edit: uploaded, try this driver
https://dl.dropboxusercontent.com/u/75270900/SiI3124_2.1.4.0_Sil_Pkg.zip
Also, I can confirm that a WD Velociraptor 600GB SATA-III made problems until I jumpered it to SATA-II, a Toshiba 3TB SATA-III work ok now for a long time (had problems initially, but that was when I formatted that drive with a Sonnet card). My other drives are SATA-II or I.
So better avoid SATA-III drives. What drive did you test with?