64位OLEDB提供程序 [英] 64 bit OLEDB provider

问题描述

SELECT *
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
                'Excel 8.0;Database=E:\x\Excel.xls;IMEX=1',
                'SELECT * FROM [Sheet1$]')

错误:

无法在64位SQL Server上在进程中加载​​32位OLE DB提供程序"Microsoft.Jet.OLEDB.4.0".

什么是64位OLEDB提供程序...

error:

The 32-bit OLE DB provider "Microsoft.Jet.OLEDB.4.0" cannot be loaded in-process on a 64-bit SQL Server.

what is the 64-bit OLEDB provider ...

推荐答案

')

错误:

无法在64位SQL Server上在进程中加载​​32位OLE DB提供程序"Microsoft.Jet.OLEDB.4.0".

什么是64位OLEDB提供程序...

error:

The 32-bit OLE DB provider "Microsoft.Jet.OLEDB.4.0" cannot be loaded in-process on a 64-bit SQL Server.

what is the 64-bit OLEDB provider ...

不支持64位OLEDB，请阅读以下内容:http://social.msdn.microsoft.com/Forums/en/adodotnetdataproviders/thread/d5b29496-d6a1-4ecf-b1a4-5550d80b84b6 [^ ]

64bit OLEDB is not supported, read the following : http://social.msdn.microsoft.com/Forums/en/adodotnetdataproviders/thread/d5b29496-d6a1-4ecf-b1a4-5550d80b84b6[^]

这篇关于64位OLEDB提供程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！