Not my job. Try looking at the Canadian government web site.
Again, not my problem if you don't understand the consequences of the existence of treaties you sign.
It is not my job to explain the binding force of treaties on US law, however I'll do it anyway so you'll see that treaties may be be as cut and dry in the US as they are in Canada. As a side note, I would be surprised if your diplomats did not understand the binding force of different treaties with the US on US law.
Although under international law, a US Treaty, a US congressional-executive agreement, and a sole-executive agreement are all the same, within the United States they have significant legal differences.
A constitutional treaty is capable of extending beyond the term of the president which negotiated the treaty and the senators who ratified it. A constitutional treaty also has the ability to legislate in areas which are constitutionally within the sole authority of the individual states. A constitutional treaty is relatively rare in the United States.
A congressional-executive agreement only requires a simple majority of congress and the agreement of the president. These agreements are the same as any other legislation passed by congress and are likewise limited in scope to the authority vested in both the legislative and executive branches of the government.
A sole-executive agreement is entirely within the president's discretion. However this agreement is limited in power to only the authority vested in the president and cannot extend beyond the president's term in office without the authorization of the president's successor.
In summary, a constitutional treaty can ban capital punishment on foreign nationals tried within the states even though Congress does not have the power to outright ban capital punishment. A congressional-executive agreement can impose tariffs and other taxes upon imported good since taxation is within the authority of congress, however a congressional-executive agreement cannot ban capital punishment. An sole-executive agreement can lift sanctions the president enforces (he controls the military), but he cannot impose tariffs, taxes, or guarantee monetary compensation since these authorities belong to Congress and not the president. Additionally, the president cannot make an agreement which violates US law.
Since I've taken the time to explain how treaties affect US law, maybe you can throw us a bone and tell us the name of this supposed treaty which grants Canadians within US borders exemptions from the DMCA.