The OLE DB provider "MSDASQL" for linked server " " supplied inconsistent metadata for a column.The column " " (compile-time ordinal 2) of object " " was reported to have a "DBCOLUMNFLAGS_ISLONG" of 0...

I am here because I got this error and hoped I would find a clue, but no dice. In your case it might be explained by nvarchar(max), however I got it on a postgreSQL boolean column which is bit on SQL server. Makes no sense.

Discard this. I found my solution, naturally outside Microsoft Tech Community. One day we can find answers about Microsoft products on MS Tech Community as well, I hope. 

Solution was to uncheck Bools as chars in DSN advanced configuration (nonsense to have it there checked in the first place).