If it doesn't read the disc when in xp even though xp detects the drive, then the drive is probally totalled.

They can be tempramental, like all dam computers

Try swapping over the IDE cables, try didfferent jumper setting like putting your cd drive on the same cable as the hard-drive (primary) and then change the jumpers accurdenly, try using the cable select jumper on any drive thats on its own on a cable.

If all else fails try taking the cd drive apart and clean up the laser lens and pull all the tiny cable apart and put them back somtimes they can get bad connections, be carfull though these are easy to break and easy to rip the cables, this might fix it i'ved fixed lots of things, that the cables come loose on.