**我INSTAL LED OFFICE2013 ON BOOTH **我有权写作并阅读TEMP文件夹 **我启用了分布式查询和AllowInProcess AND DynamicParameters')2- FROM A REMOTE COMPUTER='B' I INSTALLED SQL2012 ALSO AND I CONFIGURED IT TO ALLOW OPENROWSET QUERY; NOW THE PROMBLEM COMES WHEN I BE ON THE REMOTE COMPUTER='B' AND I CONNECT SUCCSSEFULY TO THE REMOTE SERVER AND RUN THE SAME QUERY IT GIVES ME THE FOLLOWING ERROR"Msg 7302, Level 16, State 1, Line 1Cannot create an instance of OLE DB provider "Microsoft.ACE.OLEDB.15.0" for linked server "3- WHEN I BE ON THE REMOTE COPUTER='B' AND I RUN THE SAME QURY UNDER THE LOCAL ACCOUNT OF SQL SERVER OF THE REMOTE COMPUTER I ALSO RUN IT SUCCSSEFULLY BUT AGAIN IF I RECONNECT REMOTLY TO THE SERVER OF COMPUTER A AND I RAN I IT FAILS.** I AM USING WINDOWS7 LITE X32** I INSTALLED OFFICE2013 ON BOOTH** I HAVE THE PERMISSIONS TO WRITE AND READ ON THE TEMP FOLDER** I ENABLED DISTRIBUTED QUERIES AND AllowInProcess AND DynamicParametersCAN U PLZ HELP MEWhat I have tried:** I AM USING WINDOWS7 LITE X32** I INSTALLED OFFICE2013 ON BOOTH** I HAVE THE PERMISSIONS TO WRITE AND READ ON THE TEMP FOLDER** I ENABLED DISTRIBUTED QUERIES AND AllowInProcess AND DynamicParameters阅读: OLE DB提供程序& quot; Microsoft.ACE.OLEDB.12.0& ; QUOT;对于链接服务器& quot;(null)& quot;报告错误。访问被拒绝。 [ ^ ]按照MSDN文档中提供的步骤操作:尝试时出现错误消息在SQL Server中创建OLE DB提供程序的实例:无法创建OLE DB提供程序的实例 [ ^ ]Follow the steps provided in MSDN documentation: Error message when you try to create an instance of an OLE DB provider in SQL Server: "Cannot create an instance of OLE DB provider"[^] 这篇关于如何使用openrowset打开xlsx文件?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持! 上岸,阿里云!