对OLE DB提供程序“Microsoft.Jet.OLEDB.4.0”的临时访问被拒绝。您必须通过链接服务器访问此提供程序 [英] Ad hoc access to OLE DB provider 'Microsoft.Jet.OLEDB.4.0' has been denied. You must access this provider through a linked server

问题描述

是否有任何人可以解决此问题？



对OLE DB提供程序Microsoft.Jet.OLEDB.4.0的临时访问权限已被拒绝。您必须通过链接服务器访问此提供商



我从SSIS尝试以下查询时得到此

将插入 OPENROWSET（'  Microsoft.Jet.OLEDB.4.0'，'  Excel 8.0; Database = D：\ DynamicExcelFile16032012.xls'，'  SELECT ProductID，ProductName，ProductDescription，ProductPrice，SupplierName FROM [ABC $]' ）EXEC ProductSearch @ProductName = '  ABC'    

解决方案

'） EXEC ProductSearch @ProductName = ' ABC'

参见

http://support.microsoft.com/kb/327489 [ ^ ]

Does any one have solution on this issue ?

Ad hoc access to OLE DB provider 'Microsoft.Jet.OLEDB.4.0' has been denied. You must access this provider through a linked server

I am getting this when tried to below query from SSIS

Insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=D:\DynamicExcelFile16032012.xls','SELECT ProductID,ProductName,ProductDescription,ProductPrice,SupplierName FROM [ABC$]') EXEC ProductSearch @ProductName ='ABC'" 

解决方案

') EXEC ProductSearch @ProductName ='ABC'"

see
http://support.microsoft.com/kb/327489[^]

这篇关于对OLE DB提供程序“Microsoft.Jet.OLEDB.4.0”的临时访问被拒绝。您必须通过链接服务器访问此提供程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！