Need as much detail as you can give re the existing HW to get a sense of what components can be moved to new system.
MB....make/mfg, model and mb revision #
PSU ....make/mfg and model# ...20 pin or 24 pin ?
Video...AGP 2X, $X or 8X (make/model)
RAM ....PC100, PC133 DDR??? (download CPUZ ...it;ll tell you about your current MB, CPU and RAM.
Have you tried uninstalling the CDs in 'Device Manager' and restarted the PC... sometime getting the CD back is as simple as that.
I am in the market for a new motherboard and cpu as my optical drives are no longer detected. I currently have a 2.0 ghz system with 768 mb of RAM running XP Pro. I have a video card and sound card which I am very happy with so onboard sound/video is not necessary. I am looking to spend less than 200 dollars and am unsure of whether to go with AMD or Intel as well as which mother boards to look at. I need at least 4 pci slots, but more would not be better. I am afraid of buying a cheap bundle and having problems. I am somewhat ignorant when dealing with hardware so please bear with me. Any help would be greatly appreciated.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic