Have you tried to extract your data by using Linux Life CD?
You could try using the chkdsk X: /r command , where X is the name of the letter you must put for your hard drive.
When talking about connection, have you tried connecting it through another USB cable? Sometimes where there's not enough power supply the drive can't spin up therefore cannot be accessed.
Hope this helps.