As mdd1963 said it might be a bad IDE cable.
Try replacing the 40pin IDE flat ribbon cable.
Also take the drive with a new or known working IDE cable and plug into another computer and see if it works there, if it does you will know it's not the DVD drive itself. If you have the same problem or another computer then you will know with virtual certainty that it IS in fact a broken DVD drive.
Good luck :-)