CG is absolutely correct you not only need to install the Raid Driver as supplied by ASUS but you also need to follow the instructions in the M'Board book as well.
Without the mass storage drivers Windows will be unable to load as no matter what RAID configuration you are running Windows will just not see the drives properly. There is one other thing to look out for with the ASUS SATA data leads you have to be careful that they do not become partially dislodged from either the HDD or the M'Board as these leads are very stiff and need to be bent so that they plug straight into both ends, but while this is not your current problem it is still something to look out for.
As you have said with an IDE drive the computer will boot but if you connect just one of the SATA Drives you just get a blank screen after the POST so the M'Board is attempting to access the SATA drive but the correct drivers just are not there for it to work properly. You could also try not using a RAID ARRAY if you have the time and just install Windows onto a straight SATA drive to confirm that the SATA controller is in fact working.
With those ASUS M'Boards you also need to have the SATA drives plugged into the right sockets or they will not act as a RAID ARRAY so again consult your M'Board book as it is all in there as well as the correct driver on the CD that came with the M'Board. Failing that you can always install your IDE drive and download the M'Board Book and correct drivers from ASUS and it wouldn't hurt to make sure that you have the Latest BIOS as well.
Lets know how you get along.
Col