We're about to head for a party but for the last few minutes I've been trying to get gphoto to talk to my new Kodak DC3200. It took a code change to the DC3200 support to get it to talk at all (some confusion about retrieved baudrate==0), and I haven't gotten it to list the available pictures yet.
The DC3200 isn't very sexy (1 megapixel, fixed focus/focal length lens) but I got it for 60US after rebate so I'm not complaining. It has only 2MB on-board, which is enough for only 6 shots at the highest resolution, so I've ordered a 64MB CompactFlash card. That should bring the capacity up to nearly 200 shots. I ordered a CompactFlash PCMCIA adapter as well (around 5.50US) so I'll be able to ditch the slow serial interface.
