did you not check while buying it or atleast should have checked after buying it. Did you check using it on a different system?
Since, you have mentioned that you have used every possible method to get it working.
Have to checked the following
Drive not enabled in the BIOS
Serial ATA drivers are not properly installed
Faulty or unplugged data cable
Drive is not spinning up
Incorrect jumper settings on the drive
It's can be a possibility that the driver being used by the OS is not compatible with the drive.Check all these or else the hard drive is faulty.
Please let me know about this.!