My 3rd gen will not connect to pc

It has a dodgy connection. I was having to hold the wire in, but now it won't pick it up at all (the screen turns on when the lead is in, but won't connect) is there anything I can do? Thanks for your help.