What do you mean by it's not working with the camera? Is that the camera does not mount when you plug it in? Do other USB connections, e.g., when you plug in a USB stick or some other USB device? Is this USB connection direct or are you using a USB port connected to another device, e.g., an external drive, a keyboard? Open iPhoto and go to Preferences > General and see the pull-down menu for "Connecting camera opens." Maybe it's set to not open anything.