My pioneer DVD-ROM does not recognise DVDs anymore, when I put a DVD in and try to open it just says "please insert a disc in drive F:" data and audio cd's work fine, so I've ruled out a connection inside my PC being loose.
The dvd player is a few years old now, but It's strange that it reads normal cd's ok just not DVDs.
I'm using Windows XP and have a CD-RW as a second drive.
How long as this problem occured?? Only a friend of mine had exactly the same problem.. but his was a combo drive though similar to yourself it read CD-ROMS ok, but did not like reading a DVD, kept hanging up on him. Eventually it was a case of updating the Drivers for the DVD device to work..I see you have tries that. Is it worth trying to do a system restore to a time when you knew it was working maybe there was something you installed recently that affects the DVD???
Just a guess, whether that helps, then not sure what else!!