My main machine is an early 2008 Mac Pro. It's hard to believe it's four years old already... In any case, the DVD drives fail about once a year due to dust build-up. I replaced the original one with a PATA drive from a donor, but the new drives are all SATA.
Here's how to install a SATA DVD drive in the 2008:
Useful info.