Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Linked Server   (RSS)
Friday, May 08, 2009 1:55 PM

Msg 7399 - The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "<linked server>" reported an error. Authentication failed.

I’ve seen this one a few times lately. In SQL Server there is a linked server to Access\Excel etc. Most of the times it works well, however, every now and then we get this: OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "<linked server>"
Posted by maspeng | 1 Comments
Filed under:
Wednesday, July 23, 2008 10:20 AM

OLE DB provider "MICROSOFT.JET.OLEDB.4.0" for linked server "(null)" returned message "Unspecified error".

The scenario: You want to use a linked server (directly or indirectly) in SQL Server using the OleDb provider. With this provider you wish to use, for example, the OPENROWSET query against a file of some sort, *.txt, *.csv, *.xls, etc. The problem: You
Posted by maspeng | 5 Comments
Filed under: ,
 
Page view tracker