Camera randomly re-connects to PC
No, but if you have another computer entirely that it works on, then you know that the cable is good.  This means it must be the firewire card or drivers on the PC that isn't working that is messed up.  I'd first try uninstalling/reinstalling the firewire card and drivers and if that doesn't work, I'd try a new card.