They are pretty cheap:
As long as you have a standard bay free any of the above will work.
You could try one last thing before binning the old drive.
Open up device mangager, scroll to your DVD drive, right click and choose remove.
Re-boot the PC and see if your drive has come back to life...could be a flaky driver.