June 11, 2014 at 8:29 am
Hi all,
I'm trying to run this code, which worked on SQL 2000, on 2K8:
SELECT [Business Unit]
,[Department]
,[Ext :]
,[F9]
,[First Name :]
,[Last Name :]
,[Mobex :]
,[Mobile :]
,[Sub Department]
FROM MyCompanyStaffPhoneList...Sheet1$
However it just returns this 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.
Any ideas how to resolve?
Cheers,
Jake
June 11, 2014 at 8:34 am
maybe will help you
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 11, 2014 at 10:17 am
Didn't work, tried installing the accessdatabaseengine_x64.exe /in passive mode, but it just disappears.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply