This card should be working even without the proper windows drivers, only a blank screen and a monitor in standby simlpy means problems on a lower level than drivers.

You are sure your vga card works? You are sure that the monitor and card have at least one compatible frequency and resolution area? Normaly they have.

I suggest the following, if everyone's else advice above already failed:
start with as less components and requirements as possible, and see if you can get the signal to work. Then slowly put things back.

So basicly start your box with only your motherboard offcourse cpu and ram, and your graphic card, disable the onboard video (read the manual how to do that, probably requires you to change a jumper).

If that works, figure out the conflicting components, probably an IRQ issue like said before.

Finaly to have not to much trouble with your windows, connect all old stuff and the old onboard video, go to windows set the video settings to standard VGA, nothing fancy just plain old VGA, shutdown your box, disable onboard video, plug in the PCI card, and boot your box, Windows will recognize the new hardware, put in your CD and there you go.

A sometimes forgotten thing is that many motherboard manufacturers forsee certain slots for certain cards, and assign IRQ's accordingly. This may sound very strange, but it's a very good possibility that your card is unable to work in a certain slot and certainly not in combination with certain cards in other slots, cause of IRQ sharing. So therefor it's important to see if your card can run solo on the mobo without other devices connected like soundcard, PCI modem, ... try several pci slots for your card.
Probably there are pci slots with shared IRQ's and one or more without a shared IRQ, this can be checked in the manual or by fail and error. Read out the auto IRQ assignments in Bios when you replace the card, this way you can later assign the IRQ's yourself accordingly.