I've had similar (with the same camera too), it works on 1 out of 4 pc's I've tried it on, the one it worked on, just plugged card bus Firewire card with the camera connected to it and it all just installed and worked fine.
Since bought anther make of firewire cardbus card fo rmy own PC's , and not been able to get it going at all on that, need to borrow that original firewire card from work again to prove if its a problem with the card or not
This does seem to be common issue - with firewire I mean, not the camera, quite a few similar reports out on web
There is a XP bug fix from MS regarding " enumeratiing ports" or similar for firewire not detecting devices - have a look for that - didn't help in my case though
This one
Also some referneces here to putting the old firewire driver on instead to fix things
Link