Linked Server - SQL Server Forums

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

General SQL Server Forums

New to SQL Server Administration

Linked Server

Author

Topic

Muzokh
Starting Member

21 Posts

Posted - 2011-11-23 : 17:09:22

Hi All

I am using SQL Server Database 2008 and I want to create a linked server and link it to Microsoft Access database and the access database file name is Nwind.mdb.
I issue the command in the SQL server Management Studio like this

execute sp_addlinkedserver 'North','OLE DB Provider for Jet',
'Microsoft.Jet.OLEDB.4.0','d:\sql_server\Nwind.mdb'

and receive the message

Command(s) completed successfully.

now i want to query the customers table in access database and issue the following command

select * from North...customers

when I click execute button then I receive the following message.
Msg 7308, Level 16, State 1, Line 1

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.

Please help me out

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-11-23 : 17:13:03

http://www.google.com/search?rlz=1C1GPMD_enUS313US313&aq=f&gcx=w&sourceid=chrome&ie=UTF-8&q=distributed+queries+because+the+provider+is+configured+to+run+in+single-threaded+apartment+mode

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Muzokh
Starting Member

21 Posts

Posted - 2011-11-23 : 18:07:27

Thanks for the link, but I went through all the links and didnt find any proper solution.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources