Post reply

SQL 2000 linked server to MSDAORA returns "provider did not give any information"

  • March 6, 2007 at 4:42 am

    #75133

    Hi, I have a linked server setup in SQL 2000 using "MS OLE DB Provider for Oracle" to connect to a Oracle 9.2 DB on another server.

    This works fine apart from when the Oracle database is being backed-up, in which case any query against it returns: -

    Step Error Source: Microsoft OLE DB Provider for SQL Server

    Step Error DescriptionLE DB provider 'MSDAORA' reported an error. The provider did not give any information about the error. (Microsoft OLE DB Provider for SQL Server (80040e14): OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005: The provider did not give any information about the error.].)

    This is OK when the backup is running but we could be missing important messages if the Oracle errors are not able to be passed back correctly.

     

    Any help would be much appreciated.

  • March 6, 2007 at 9:42 am

    #693361

    Linked servers are notoriously bad at passing errors back...

  • March 8, 2007 at 5:20 am

    #693773

    Both the Oracle & SQL servers have been migrated to newer hardware (but same software version) but it used to work fine??

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply