I’m having very similar problem:
SH-223Q, worked fine, broke (I probably noticed when I tried to rip a CD if I remember correctly);
DVD’s - no read (spits out the holder and asks for more), CD’s - reads very slowly (although, when I remap the drive to any other letter the speed suddenly jumps for about a second);
vista32, device manager shows all ok, flashed official firmware, reinstalled vista’s suggested drivers several times, reconnected dozen of times, the drive works fine on other pc (they tried it with eSATA), I haven’t tried to boot;
There are six SATA holes in the motherboard, the HDD is on first, the dvd drive is on third. Heres some of the motherboard manual. //EDIT: Sorry for not rotating
There are three settings for SATA in BIOS: IDE/RAID/ACHI. Currently it is on ACHI. RAID is no good here, eh?
So, any ideas?