Depending on your purpose for the adapter, it may never work.  Many
newer boards have their own IDE channel hanging off a certain way that
it won't boot.

SATA native DVD-burners are $20-$30 at MicroCenter, might it just be
easier to pick up a new one?  (For the better part of a decade I've
just bought whatever Samsung drive was available; haven't had trouble
yet)

Many lower-end boards forgo IDE channels altogether; but at the
$90-$150 mark, include one that they've added via some third party's
controller chip.