If you can't get the card to show up in device manager at all, we're talking not even the basic "Ethernet Controller" listing, try using another PCI slot.
If you can't get the driver to install off the CD try the latest off the website, or the ones listed here. If all else fails try this driver:
http://www.phoenixnetworks.net/atheros/Atheros-7.0.0.119-Vista-RC2-5744.zip
That is a generic Atheros driver that has a driver for the AR5002 chipset, which the DWL G520 uses however SuperG(108Mbps) will not be usable. It will show up as "Atheros Wireless Network Adapter" but should work just fine.
For those who managed to get as far as pantherjad, i.e. disabling the device before shutting down and reenabling after starting up, there is an easier way.
Check devcon http://support.microsoft.com/kb/311272. You'll need to dump it in a convenient location such as "C:\Devcon" or a similar spot, try not to put any spaces in the folder name. Make sure you have the folder with devcon.exe in it and hold shift and right click in a blank area in the folder, then release shift, and left click "Open Command Window Here"(or just open a command prompt in the devcon.exe folder if you already know how to do this). In the command prompt type:
devcon.exe find *
This should list all devices in your system, look for the one for your wireless card. The right side of the : will list the name of the device, the left side has the hardware ID, it should begin with "PCI\....". Note the part of it that says "VEN_XXXX". Now in the same folder create a new text document called disable.bat(name doesn't matter, but the extension does). In the text document put:
C:\Devcon\devcon.exe disable *VEN_XXXX
repeat in a new file called enable.bat but this time put:
C:\Devcon\devcon.exe enable *VEN_XXXX
Then fire up gpedit.msc (Start, Run(or Search), gpedit.msc). In the tree listing(left hand side) go to Computer Configuration > Windows Settings > Scripts(Startup/Shutdown). Open Startup and click Add, browse to the "enable.bat" and add it. Do the same with Shutdown and "disable.bat". Close it and try to restart. You should be able to boot without locking up, if you do lock up restart, boot into safe mode(mash F8 when booting up)(without networking enabled), disable the wireless card, restart, boot into windows normally, and then re enable the card. Now check to make sure you don't have the bat files mixed up, such as disable on startup and enable on shutdown(check inside the .bat files as well). If it's still locking up then post in here.
If all else fails install linux(or get a new wireless card). Jk, but seriously on some motherboards this card is very finnicky in windows 7, so good luck.