Sql链接服务器和列加密 [英] Sql linked server and column encryption

问题描述

我在从链接服务器查询数据库时启用了列加密的SQL Server 2016我收到以下错误



消息7356，级别16，状态1 ，第1行

链接服务器itor的OLE DB提供程序MSDASQL为列提供了不一致的元数据。对象itor。dbo。chels_view的card_num列（编译时序号3）在编译时报告的DBTYPE为130，运行时为128。



查询在原始服务器上正常运行。



我尝试过：



我试图搜索谷歌并检查SQL服务器论坛。

I have SQL server 2016 with column encryption enabled when querying the database from a linked server I am receiving the error below

Msg 7356, Level 16, State 1, Line 1
The OLE DB provider "MSDASQL" for linked server "itor" supplied inconsistent metadata for a column. The column "card_num" (compile-time ordinal 3) of object ""itor"."dbo"."chels_view"" was reported to have a "DBTYPE" of 130 at compile time and 128 at run time.

The query is working normally on the original server.

What I have tried:

I tried to search Google and checked SQL server forums.

推荐答案

我的第一个猜测就是你已经为命名列指定了错误的类型（ card_num ） - 你期望一个字符串并且它返回一个 int ，或者相反。

My first guess is that you've specified the wrong type for named column (card_num) - you're expecting a string and it's returning an int, or the other way around.

这篇关于Sql链接服务器和列加密的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！