A quick google of 'Sony DSC-W30 linux' showed that mounting might only work since kernel 2.6.16, ie. from debian etch or a sarge kernel from backports.org
Trrhaa, I installed a etch version of debian which uses 2.6.17. Now I can do a 'mount /dev/sda1 /mnt/camera' and everything works fine.