Fortunately, I have another computer and I tested the card in it. So the card definitely works. This is also my second motherboard. I thought the AGP slot didn't work at first so I returned it. Now the same thing is happening with the second mobo.
I just wanted to say thanks for all the help. The culprit turned out to be the power supply. I swapped them out and it now works (the screen comes on and everything).