Beat bet with Knoppix, IMHO, is try looking with the PCman file manager to see if the hdd is recognized at all - if so, try right-clicking it to mount, then recover your data by writing it to another drive (maybe even the USB drive.) You might also like Hiren's Boot CD - it has LOTS of good tools for fixing systems that are broken in the way it sounds like yours is.

Krishna