WD40 is probably the solution (pardon the pun!) - it sounds like a pin isn't connecting properly. Just hope that it isn't a dry joint inside the plug!

I've seen that reboot thing happen. One possibility is that the BIOS was set to look only at the AGP, and can't cope with nothing being there. A BIOS reset may well fix it.