The problem for some SATA controllers is that they don't act as if they are IDE controllers and, thus, need special drivers. Furthurmore, some are barfy with ATAPI devices, as they don't have the protocol implemented correctly.
I have and nForce3-based board, and my drive with the SATA adapter...