My DVD writer consistantly failer about 70% into burning a DVD. Erroe indicates the SATA controler cannou be found. My hard disk runs fine, it reads cd/DVD fine, just stopped burning DVD's. Recently upgraded to windows 7. Burning using Roxio 10 (not 2010) Ir replace the drive, but problem continues.
First, download imgburn (http://www.imgburn.com/) and try burning with that program. It's a very solid program for burning. Next, you can try slowing your burning speed down. Drop it down to 4x/8x just to see if it makes a difference.
Next you could try updating the firmware of the cd/dvd drive, although I'm thinking it's less likely the drive as you say you've already tried other drives.
You could also try updating your motherboard BIOS to the latest revision. Just a couple thoughts.