Robert to help you, you must answer all the questions put to you.
You have to remember we are trying to diagnose the fault with your answers.
Now is the IDE cable you have 40 or 80 wire? In any case try a new 80 wire cable they are cheap enough and will eliminate the possibility of a faulty lead.
In bios on the motherboard is the drive correctly recognised?
Go to hardware device manager click on the DVD drive and properties and see if windows correctly identifies it?
If you put a pressed cd or dvd does the drive recognise it, can it be played or the contents recognised in windows explorer?
What burning programs give you the error message?