I have a problem with a linked server between SQL Server 2016 Standard Edition to PostgreSQL. Some tables I can select but when I want to access to specific table I get an error.
Msg 7356, Level 16, State 1, Line 2
The OLE DB provider "MSDASQL" for linked server "b2c" supplied inconsistent metadata for a column. The column "tsv_reference" (compile-time ordinal 45) of object ""astraotoshop_b2"."product"."products"" was reported to have a "DBCOLUMNFLAGS_ISLONG" of 128 at compile time and 0 at run time.
Can someone tell me where the error is?
Thanks
1条答案
按热度按时间nle07wnf1#
我在这里找到了这个答案我终于弄清楚了问题所在。
为了防止其他人遇到此问题，一种解决方法是转到开始〉搜索ODBC数据源管理器〉系统DNS〉配置
弹出窗口打开后，在“选项”下转到“数据源”。
然后取消勾选Bols as Char，应用并保存。