SELECT * FROM OPENROWSET无法在我的机器上运行 [英] SELECT * FROM OPENROWSET is not working in my mechine
问题描述
大家好,
请帮我解决以下问题
我的系统类型:64位操作系统Windows7
带高级服务的快捷版(64位)
SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0 ','EXCEL 12.0;数据库= D:\ newfolder\test.xls;','SELECT * FROM [加载$]')
执行后上面的查询,它说错误
OLE DB提供程序'Microsoft.ACE.OLEDB.12.0'不能用于分布式查询,因为提供程序配置为在单线程单元模式下运行。
我也执行查询,但没有收益
Hi All,
Please help me for the below Issue
My system Type :64bit operating system Windows7
Express Edition with Advanced Services (64-bit)
SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','EXCEL 12.0;Database=D:\newfolder\test.xls;','SELECT * FROM [Load$]')
After Executing the above query ,It says the error
OLE DB provider 'Microsoft.ACE.OLEDB.12.0' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode.
I also Execute the query ,But no gain
EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'AllowInProcess', 1
GO
EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'DynamicParameters', 1
谢谢&此致,
Soumya
Thanks & Regards,
Soumya
推荐答案
')
执行上述操作后查询,它说错误
OLE DB提供程序'Microsoft.ACE.OLEDB.12.0'不能用于分布式查询,因为提供程序配置为在单线程单元模式下运行。 / b>
我也执行查询,但没有收益
')
After Executing the above query ,It says the error
OLE DB provider 'Microsoft.ACE.OLEDB.12.0' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode.
I also Execute the query ,But no gain
EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'AllowInProcess', 1
GO
EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'DynamicParameters', 1
谢谢&此致,
Soumya
Thanks & Regards,
Soumya
这里几个解决方案
SQL SERVER - 修复:错误:MS Jet OLEDB 4.0不能用于分布式查询,因为提供程序用于在公寓模式下运行。 [ ^ ]
OLE DB提供程序'Microsoft.ACE.OLEDB.12.0'不能用于分布式查询,因为提供程序配置为在单线程分支中运行t模式 [ ^ ]
Here few solutions
SQL SERVER – Fix: Error: MS Jet OLEDB 4.0 cannot be used for distributed queries because the provider is used to run in apartment mode.[^]
OLE DB provider ‘Microsoft.ACE.OLEDB.12.0′ cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode[^]
这篇关于SELECT * FROM OPENROWSET无法在我的机器上运行的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!