update:
I took the video card back to Canada Computers and got some tech support there. The guy tested the video card, it was fine. He said that my motherboard would not be the problem, it should support it fine since it supports a 8800 GTX. He told me it was the power supply that was the problem and i would never be able to run a 8800 gt off of a 425w power supply, so he recommended i get a better one. So now I have a 520w power supply with native PCIe connectors. After trying again, it still doesnt work. I put the old card back in, it works fine.
I still have no idea.