Some of the IDE-SATA adapters out there do work, and others don't. And some of the mSATA-to-IDE adapters also work. Some SD-Card adapters also work, but not many it seems. Sometimes they work only for drives up to 32GB, sometimes for any size drive.

The old Kingspec PATA SSDs work very well, but the newer (since 2014 or so?) PATA SSDs are really native SATA with an IDE/SATA adapter built in, and those do not work.

CompactFlash cards currently have a 100% success rate, as Tony mentioned.