+1 Yeah, that cable length thing is weird but true. Also, try pressing the microscope's 'photo' button after connecting it—sometimes it needs a nudge to switch into storage mode.
Same here. I had the same problem. It turned out I needed to use the specific, cheap cable that came with it—my better-quality cables didn’t work for data transfer.