trying to run access data thorugh linked server...

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

trying to run access data thorugh linked server...

Author

Topic

asifbhura
Posting Yak Master

165 Posts

Posted - 2011-12-08 : 03:19:52

Hello

Here is my query

SELECT *
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'C:\Users\Administrator\Documents\test.mdb;';
'NetUser';'',table1);
GO

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.

I am using windows server 2008 64 bit, sql server 2008 R2

access 2003 32 bit, I configured sql server as below

sp_configure 'show advanced options', 1;
GO
RECONFIGURE
GO
sp_configure 'Ad Hoc Distributed Queries', 1;
GO
RECONFIGURE;
GO

if i run import it is working fine...

regards

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2011-12-08 : 05:45:19

So, what is the issue?

Madhivanan

Failing to plan is Planning to fail