If the SATA card is SATA-1 you'll need to set the SATA-1 jumper on the drive. That's all I can think of.
There is clearly an error there, though, given the "error"(red circle with a line) icon being overlaid atop the standard drive icon.
Your assumption that I used "Update Driver" was correct. There was no CD that came with the SATA card and all indications seem that the HD must be defective.
I checked with MS and found this unit is compatible with Windows XP, and with the DVD working fine with the SATA card, it would seem the card isn't the problem.
Looks like this HD was a DOA.
Thanks for the help.
your line of reasoning is a post hoc fallacy. Not being able to access the drive may or may not have to do with the card; there is no way you could possibly know for sure that the SATA card is fully compatible with the HD; the only way to confirm the HD is a "dud" is to actually connect it to a computer whose SATA connections are known to work with Hard Drives. The fact that the DVD works is purely consequential; Most DVD drives work in SATA-1 mode, whereas newer Hard drives work in SATA-2 mode at least, and you would need to place a jumper on the drive in order for it to work with a SATA-1 controller.
Additionally, while it is certainly by design that the card identifies as a SCSI device, one cannot conclude that it being identified as a SCSI device is not part of the problem.
While it seems logical to conclude that since device X connected to adapter Device P isn't working, and that Device Q connected to adapter Device P works, that device X isn't working. It's a premature conclusion IMO. The only true way to confirm that Device X does or does not work is by connecting "device X" to the actual interface it uses, not to a adapter of any description.