I had to update my bios for my sata DVD drive to work. Did you update your bios to a current one? If you bios doesn't see it then XP can't either, I know you said that Vista see's it. I never installed any drivers for my sata DVD drive. Are you running a dual boot system(XP & Vista)?
I might be simple but if you have vista and it sees the sata hard drive, and you do not want to dual boot both Win XP and Vista. You should have no problem keeping the bios configuration that allows Vista to see the hard drive.