我正在尝试将链接服务器添加到Access数据库.我使用以下sql代码来执行此操作.
exec sp_addlinkedserver @server = 'Test',@provider = 'Microsoft.Jet.OLEDB.4.0',@srvproduct = 'OLE DB Provider for Jet',@datasrc = '\\srv\public$\CM Database\Data\sysConfig_dat.mdb' go EXEC sp_addlinkedsrvlogin Test,FALSE,Null,Admin,Null
但是当我跑这个……
select * from Test...tblProduct
我收到这个错误……
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. what
am i doing wrong?
