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

来源：互联网发布：现代诗知乎编辑：程序博客网时间：2024/05/07 13:37

在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