用于SQL Server的Microsoft OLE DB驱动程序（msoledbsql）链接服务器排序规则错误 [英] Microsoft OLE DB Driver for SQL Server (msoledbsql) linked server collation error

问题描述

尝试在两个2016实例之间的链接服务器中使用msoledbsql提供程序（两者兼容性为130）并在连接语句中出现以下错误：

Trying to use msoledbsql provider in a linked server between two 2016 instances (130 compatability on both) and getting the following error on a join statement:

不能解决"SQL_Latin1_General_CP1_CI_AS"与"SQL_Latin1_General_CP1_CI_AS"之间的整理冲突和"Latin1_General_CI_AS"在等于操作。

从两侧检查每个对象，列，类型等...并且使用 " Latin1_General_CI_AS" 。核对 链接服务器使用SQLNCLI提供程序完美运行。

Checked every object, column, type, etc... from both sides and cannot find anything using "Latin1_General_CI_AS" collation.  The linked server works perfectly using SQLNCLI provider.

感谢任何帮助。

推荐答案

我没有看到。再说一次，鉴于您需要明确使用BEGIN DISTRIBUTED TRANSACTION，我没有太多使用该提供程序。

I have not see that. Then again, given that you need to explicitly use BEGIN DISTRIBUTED TRANSACTION, I have not used that provider much.

我会追踪远程服务器上的内容。跟踪SP：StmtCompleted，但也跟踪错误事件。

I would trace what is going on the remote server. Trace not only SP:StmtCompleted, but also error events.

这篇关于用于SQL Server的Microsoft OLE DB驱动程序（msoledbsql）链接服务器排序规则错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！