OLE DB provider "MICROSOFT.JET.OLEDB.4.0" for linked server

最新推荐文章于 2019-05-07 20:41:02 发布

原创最新推荐文章于 2019-05-07 20:41:02 发布 · 1.8k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#server #null #query #windows

本文介绍在WindowsServer2003上使用OpenRowSet和OpenDataSource时遇到“Selectedcollatingsequencenotsupportedbytheoperatingsystem”错误的情况，并提供了具体的错误信息。

在Windows Server 2003 英文标准版使用OpenRowSet、OpenDataSource时会报以下错误：

OpenRowSet

OLE DB provider "MICROSOFT.JET.OLEDB.4.0" for linked server "(null)" returned message "Selected collating sequence not supported by the operating system.".
Msg 7320, Level 16, State 2, Line 1
Cannot execute the query "SELECT `Tbl1002`.`CellID` AS `Col1004`,`Tbl1002`.`Longitude` AS `Col1005`,`Tbl1002`.`Latitude` AS `Col1006`,`Tbl1002`.`RNCID` AS `Col1007` FROM `sheet1$` `Tbl1002`" against OLE DB provider "MICROSOFT.JET.OLEDB.4.0" for linked server "(null)".

OpenDataSource：

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Selected collating sequence not supported by the operating system.".
Msg 7320, Level 16, State 2, Line 1
Cannot execute the query "SELECT `Tbl1002`.`CellID` AS `Col1004`,`Tbl1002`.`Longitude` AS `Col1005`,`Tbl1002`.`Latitude` AS `Col1006`,`Tbl1002`.`RNCID` AS `Col1007` FROM `Sheet1$` `Tbl1002`" against OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".

http://blog.youkuaiyun.com/apassion1/article/details/5409815