My tentative recommendation, based on personal experience, for currently available IDE to SATA adapters is the SinLoon brand ones that are base on the Jmicron JM20330 chip . They are available on Amazon and probably elsewhere . That said, you will never get more than 33MB/second out of the integrated IDE ports on your board, no matter which adapter you use so I don't see much use in going in that direction . Also, the BIOS on your board likely will not properly handle drives greater than, at most, 127GB (if even that), connected to its onboard IDE ports .
As far as SATA PCI cards go, the Promise SATA150 TX2 PLUS is a good choice, if you can find one at a reasonable price and . If you can get a working one a SIL3114 should work well too . Keep in mind, though, that since you are using an SSD, the SIL3114 based cards will not pass TRIM commands under DOS at least (using RLOEWE's TRIM utility) .