ruthless,
You are correct. You should ONLY have one power connector going to the drive. (Two conectors will destroy the drive!)
In the BIOS, I believe you want "P-ATA + S-ATA", and also right below it, make sure "S-ATA Keep Enabled" is set to "Yes".
- rp