CODEWITHSUNDEEP
sql-serverlinked-server
jcoke
jcoke

Reputation: 1891

Receiving a `inconsistent metadata` error when querying a table from a linked server

SELECT * FROM [POSTGRESSQL35W].[Briefs].[public].[planbrief]

I've been scratching my head for hours just trying to run the query above. I can successfully retrieve data from certain tables, however, for this particular table it throws the error below. Does anyone know how to circumvent this ?

Also, I already know about the function OPENQUERY, which I tried and it still does not work. 

Msg 7356, Level 16, State 1, Line 5
The OLE DB provider "MSDASQL" for linked server "POSTGRESSQL35W" supplied inconsistent metadata for a column. The column "rewarded" (compile-time ordinal 50) of object ""Briefs"."public"."planbrief"" was reported to have a "DBCOLUMNFLAGS_ISLONG" of 128 at compile time and 0 at run time.

Upvotes: 3

Views: 3649

Answers (1)

jcoke
jcoke

Reputation: 1891

I finally figured out the issue.

Just in case anyone else is having this problem, a workaround is to go to Start > Search ODBC Data Source Administrator > System DNS > Configure

Once the pop up window opens, under Options go to Datasource.

Then untick Bools as Char, apply and save.

Upvotes: 4

Related Questions