Is that the DVD ROM is failing and will read DVDs perfectly but not CD's I've mostly seen this on Samsung Drives though it could be related to others.
There is also another possibility here and that is the actual DVD ROM is incapable of sending the correct signal to the M'Board to see a Bootable CD in the drive, this happened quite a lot with the early DVD ROM's and the only cure it to temporally replace the DVD with some type of working CD Drive and try again. I would also suggest using known good IDE leads as even new leads can be faulty particularly if they are of the 80 cable type and not the 40 way ribbon.
I think that you'll find that will cure your problem. Sometimes a Firmware Upgrade on the DVD ROM will do the trick if there is one available.
Also there where several M'Boards back in the old P3 days that where unable to read from a DVD ROM and required a CD ROM to boot from that's a problem with the BIOS as it's unable to recognise the output of the DVD for some reason.
I really would suggest changing the DVD ROM Drive to a CD ROM Drive and attempting to load XP as a clean install and see if that works which I think it will. I seem to remember some trouble with the Intel 815 Chip Set M'Boards and available BIOS that didn't allow it to recognise the data being transmitted from a DVD ROM. If I remember correctly there was something about the firmware in the DVD Drive clashing with the BIOS that caused the problem though don't quote me on that as it's been a very long time and I'm not overly sure that's the reason but I seem to remember something about it causing problems and we had to always have a CD Drive of some kind as the Secondary Master be it a burner or reader it worked but if we used a DVD Rom it never would work.
Also have you tried using a Live Linux to see if the hardware will actually work? If that will load you can rule out he M'Board and at least the IDE Controller that the CD/DVD is on though for something this old only try a CD version of Live Linux not one of the DVD Versions as they just will not work.
If you can get the system to load any form of Live Linux you can then try the Ultimate Boot CD available from http://tinyurl.com/3jnpy and run some of the Diagnostics like CPU, RAM and M'Board tester there is also a HDD tester built into the CD and as everything goes into a RAM Drive you don't have to worry about any corruption of the HDD just like any Live Linux.
If you use Knoppix you can actually read any NTFS HDD Partition and The Ultimate Boot CD has a utility that wipes and totally erases the HDD by writing 0's to every sector several times over I think from memory that it's called [b]Something Boot & Nuke.[/b] This will make certain that the HDD is really empty and not causing any problems.
With these old M'Boards you [b]Can Not[/b] use the CS option as this wasn't supported by these IDE Cables so you need to set the HDD to Master on the primary IDE Channel and the CD ROM to Master on the Secondary IDE Channel to make sure that things will actually work.
Col