I then tried the video card in another computer (with the same exact hardware) and it worked fine, so it's not the card. As of now I'm forced to use my onboard memory, but that is less than acceptable and I can't play my brand new MMORPG I've been excited about.
The video card doesn't show in the Device Manager of Windows, and it still will never show anything on the monitor when I try to use it. I've removed and replaced it a few times in case it was part of the way out of the AGP port (a common error) but it was no good.
I'm using a Micro Star Phoenix MS-6390 motherboard with the latest BIOS.