Sorry, I should have clarified. The "contains no columns that can be selected" error I'm getting is when I try to Script Table as | Select To | New Query Editor Window (having updated the [LinkedServerName] and [TableName] values to the ones I'm using).

Edit. (sorry, it's been a busy Friday). I'm getting the "missing ADSPROF" error when using the Connection String and the "contains no columns" error when using the 64-bit DSN.