Ok, I think I have more needed info about the mother board. BIOS Type: Award
BIOS Date: 11-01-2004
BIOS ID: 11/01/2004-KM400-8237-6A6LYA0DC-00
Motherboard: HP/ASUS A7V8X-LA (Kamet 2)
The hard drive it won't detect is a SATA 3.5 Barracuda 500GB.
You may need to add a jumper to the pins on the back-end of the drive to take it from 3.0Gb/s to 1.5Gb/s. Boards that where originally IDE have a 1.5 Gb/s limitation. There should be a diagram on the top of the drive that shows where to place the jumper cap.