1) Make sure that the SATA port is enabled in the BIOS, and that all appropriate cables are detected. Most of the cards will require power, and it sounds like you connected that.
2) Some really cheap IDE to SATA bridges won't work with optical drives (e.g. $3 ones from eBay sometimes). Try an IDE hard drive. If it works with a hard drive, but an optical drive, join the crowd. I've bought them before and been screwed by this.