Native support under XP wasn't intended for the DVD world. What it appears you have done is make sure the h/w is capable of supporting the DVD-rom, you need to try the player s/w side. In many ways the use of the VLC player accepts this task well. It provides for it own needs whatever is required. This side-steps all the other media or windows provided players that can cause issues. if it works under VLC then all is well for it. The other players then need to be re-installed or configured again. Google for VLC, install and come back with results. Otherwise, I'm afraid a XP repair of the OS maybe the only option, other than a re-install which removes many unknown setting that may have been touched in some process. Also, check into the install of "codecs" that can be hosed, I use Klite codecs for quick fixes. These either replace or become supplemental to current codecs.
Just recently my dvd/cd rom stopped working, so i bought a new one and it is doing the same thing.
My original dvd/cd HP (sh-s223f) and the new sony external drives both show as working in device manager and even seem to be looking for a disk at times but give up. Whats funny is that the original one is internal via usual cabeling and the other is usb.
My system is xp pro fully updated, I have tried the regedit of upper and lowerfilters, windows "fixit", uninstall and reinstall of the device(s) and fresh in stall of drivers, firmware updates, recovery to way back before when i last used it. I also deleted the IDE ATA/ATAPI Controllers and reinstalled. Always using disks i know that worked before as well as changeing them just in case.
My 3 year old uses the computer unatended at times and was thinking that he might have ticked a box and turned something off somewhere but after constant googleing have seen others have a similar problem apart mine being 2 devices (one being usb).
Any ideas would be great, thankyou.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic