After reading through this thread here's what I had to do to get it to work on my ASUS m4a89gtd-pro motherboard.
-I had to have the ATA controller enabled in the bios. (I had disabled it since I did not have any ATA devices, everything was SATA)
-Installed the driver from jmicron for my 36x chipset.
-Plug in drive Power, Then SATA cable, THEN turn it on.
-Right away after turning it on I'd go into Disk Manager, but no disk found. Right click on the left menu and select "Rescan Disks" and then device would show up in the list.
-For some reason once I made the disk active and tried to format it would hang/freeze. But for some crazy reason (don't ask me why) if I made the disk active, closed disk management, open my computer double click on the new drive. It would prompt me to format and bam! Formated fine, no problems works perfect now.
Why I had to go thorugh all that crap I have no idea, I'm just gonna chalk it up to bad drivers and Windows 7.
This was on Win7 Ult x64. Was initially using USB 2.0 which worked like it always should and does. But I just had to have the speed of eSATA. Hope that helps someone out there, took me a good two hours to coax it into working.
GL!