Chad,

Thank you. Turned out I needed to make a couple of changes to the properties for the MSDASQL provider. Didn't have to do that on the x32 linked server (or at least I don't remember doing it).

I wish you had seen this post earlier, I have spent a lot of time looking at an older version of the x64 ODBC driver and trying to figure out how and where to install it manually.