Arg, missed the edit deadline.
What I meant to say is that RRSP accounts can be set up to be exempt from some or all of the withholding tax, but this requires filling out the IRS's W-8BEN form, and definitely should be done with the assistance of your broker.
For a regular, non registered trading account, you can claim a foreign tax credit as CAinPlap described.