I recently got email from blog reader with following error.
MS Jet OLEDB 4.0 cannot be used for distributed queries because the provider is used to run in apartment mode.
The fix of the same is very easy.
sp_configure 'show advanced options', 1; GO RECONFIGURE; GO sp_configure 'Ad Hoc Distributed Queries', 1; GO RECONFIGURE; GO
If you are still facing the error after running above statement please leave a comment here and I will do my best to help you out.
Reference: Pinal Dave (https://blog.sqlauthority.com)