Posted by Erland Sommarskog on 10/01/21 11:39

David Kirkman (foxwaycomputing@gmail.com) writes:
> An Access 97 linked server in SQL Server 2K has recently stopped
> working. In Enterprise Manager, the following error message appears
> when attempting to view the list of tables in the linked server:
>
> Error 7399:OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
> OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'
> IDBInitialize::Initialize returned 0x80004005: ].
>
> This linked server has not been used recently and in that time Win2K
> SP4 and SQL Server 2K SP4 have both been applied. We now need to use
> this linked server on a regular basis so any help will be much
> appreciated.

Check out in master..sysservers how the server is set up. Pay particular
attention to the providerstring column.

Or just drop the server, and set it up a new.

Also, verify that the connect string you use works from a regular client
as well.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Views vs Stored Procedures, whats the difference?
• Prev in forum: Re: Removing Duplicates rows from Inner Join
• Thread view: Re: SQL Server 2K Linked Access 97 Server not working

[Reply to this message]