If you are going to solve this one we are going to need some more information to help you. The problem is either the wrong drivers or the CD Rom is at fault. Might be a loose connection cable since you said it worked intermittently. Check that first.
Tell us the actual make and model of the CD ROM whilst you can see it. There will be a serial plate on the back - note anything that looks relevant and post it to this thread.