Last post Dec 20, 2011 09:30 AM by gopalanmani
Dec 20, 2011 07:59 AM|Marwa Ahmad|LINK
Hi, I got this error:
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode.
When I run this SQL statment:
insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\temp\marwa\MyExportedData.xls;;HDR=YES', 'SELECT * FROM [Sheet1$]')Select * From Asset Where Name = 'Data'
Note: I set Ad Hoc Distributed Queries to 1 and it did not solve the error??!! what do you suggest?
use masterGosp_configure 'show advanced options', 1;RECONFIGURE;sp_configure 'Ad Hoc Distributed Queries', 1;RECONFIGURE;GO
OS: Microsoft SQL server2003
SQL server: SQL server 2008
I do really need your suggestions.
Dec 20, 2011 09:30 AM|gopalanmani|LINK
check this url,
I hope its helps you !