There is no transit visas in the US, as there are no longer transit areas at US airports. He has to be fully admitted into the US, get his bags, go through customs, then re-check, go through security, etc for the outgoing flight.

So whether he needs a B-1/B-2 visa, is VWP, or just entering via Canadian passport depends on where his passport is from.