It is possible to use a SATA drive with an IDE connector:
However, you would be smacking on another $20 to the overall price.
I would recommend getting an IDE drive if that's what you've got to work with:
Being kinda a newbie at this type of stuff I figured I'd ask people who know. I have a Dell Dimension desktop with Windows XP SP3 about 6 yrs old. My CD writer died and I need to replace it. I have looked to replace it with a DVD/CD drive. The problem is that almost all writers are SATA I'm pretty sure I have a IDE, is this compatable? The one I'm looking at is a Sony Optiarc AD-7240S-0B 24X. Any problems I should be made aware of, is this possible?