You are right; it should work straight out of the box. Just attach it, install the ata3.driver (really important) and it should work.
However! I had the same problem you had with partitions disappearing if I ran the driver so I had to disable it.
Does "diskchange " work for you?