How to recover photos from an iPhone 3G?
Mac - iPhoto

Windows - Photo Gallery, part of Microsoft Essentials.

Both will offer to import photos from any connected iPhone

BTW, by default an iPhone will not appear as a device on the desktop, only in an app ready to 'talk' to it, iTunes, iPhoto etc.