Do you really need to the windows program? I have been using ubuntu
for the last year for my personal PC and I just plug my canon into the
usb and ubuntu asks me if i want to import the photos. If you are
looking for a cataloging program, I would suggest F-Spot or Google's
picassa. Both work great.

The thing about WINE is it is not an operating system. It is just an
emulator. The way I understand it is that when the windows program
communicates with the OS, it expects certain things to be there. the
emulator, mimics the expect behavior. One thing you camera program
might be expecting to find is its specific windows camera drive.
Since that does not exist in your linux and nobody has had the
interest to translate it, the program will fail to, minimally,
communicate with the camera.