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

最新推荐文章于 2021-01-28 09:49:49 发布

lzwxyz

最新推荐文章于 2021-01-28 09:49:49 发布

阅读量1.7k

点赞数

文章标签： server null query windows

本文链接：https://blog.csdn.net/lzwxyz/article/details/6754654

版权

在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.csdn.net/apassion1/article/details/5409815