How about BIOS updates ?
How about firmware updates ?
What happens with a PATA CD-DVD ?
Everything clean in device manager ?
VAPCMD
I've tried three different DVD SATA drives in my dual-boot XP/Vista system and the same thing happens with each one. (XP and Vista are set up on different drives.) The first couple of loads with either XP or Vista everything will run fine. Then I'll get an OS freeze in the middle of whatever I'm doing that will either stop things completely or just pause things for about a minute or two before continuing again. But after that when I boot I'll get pauses in the BIOS loading and will get jibberish when it comes to listing the DVD device. If I can still get it to load Vista it will not show my DVD drive as existing any longer in the My Computer page.
When I disconnect the SATA connector, everything runs fine without the DVD drive hooked up. If I reconnect it I'll get a couple of good boots before it all starts over again. Any help would be appreciated because these are perfectly good drives. (I do run Norton Antivirus and everything checks out.)

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic