Home > Archive > MS SQL Server > February 2006 > SQL Server 2K Linked Access 97 Server not working









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author SQL Server 2K Linked Access 97 Server not working
David Kirkman

2006-02-09, 8:23 pm

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::Initi
alize 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.

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com