Some CD ROM drives/DVD ROM drives and writers don't play well together. My suggestion is to make one the Master and thee other the slave. If this doesn't work make the other the master and the one that was master the slave. Usually one has a problem with being the slave. Also make sure you have the latest drivers installed for both drives.
Sorry if this is a duplicate post, but this problem really has me frustrated. First, let me give you some system specs.
Liteon CD-ROM LTN244
Creative DVD-ROM DVD2240E
Microsoft Windows XP, Professional, Version 2002, Service Pack 1
Intel Pentium III, 1.01 GHz, 512 MB of Ram
Now the problem.
I recieved this computer from a friend, with one Hard drive and one DVD drive. I installed a second formatted hard drive and a second CD ROM. The hard drive worked fine, but the cdroms didn't work together.
When the eject button is hit on either drive, only one drive (the DVD) would open. I just disabled the CD rom and used the computer anyway.
Then I noticed that every once in awhile the DVD rom would not autorun a disk. When I would go to open the drive in "My Computer" the drive would have dissappeared, as if it wasn't installed. The only fix for this is to reboot.
The same is true when the cd rom is running and the DVD is disabled.
Now, both drives are active. Both can be accessed. But neither drive, under any configuration that I have used, will "see" a disk. The CD rom will very seldom recognize an audio CD. The DVD will not run at all.
I have checked cables, master/slave settings, and other such problems I know of. But Nothing seems to fix it. I have used CD/DVD/CDROM cleaners, and nothing works. Could someone give a little help if they have some time.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic