|It should still recognise it as some sort of USB drive, if not your particular camera model name.|
Can you still see the images you've taken on the camera itself?
Try connecting it to another pc (don't install the software, just see if the pc recognises it).
Can the images on the card be read by using an external reader? (if you haven't got one then ask a friend or pop into your local supermarket or whever with digital processing facilities & just pop the card into their self-service machine).
"I've always been mad, I know I've been mad, like the most of us..."