Linked Server problem !

  • I try to link a Oracle Server with a SQL Server but this message always appears : "Error 7399: OLE DB provider 'MSDAORA' reported an error. OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005:  ]."

    So, I installed Oracle client 7.3.3.5.0 on my SQL Server. This server is a Windows 2000 Server SP4. When I use a "SQL Plus 3.3", little Oracle tool to query building I can connect my Oracle Server.

    But, when I want to create a "Linked Server", after that I clicked on "Tables" I receive message that you had read more high.

    I inputed this paramaters :

    "Product name : Oracle7"

    "Data Source : MyDBOracle" (Oracle DB Name)

    "Provider String : MSDAORA"

    Can you help me ?

    Olivier

     

     

     

  • What version is the Oracle database ?

    Can you make an ODBC connection on the SQL server ? (To the Oracle Database)

    You have also set the login/password in the Linked server for the Oracle connection ?

    I'd still be going for a later client....

    DB


    The systems fine with no users loggged in. Can we keep it that way ?br>

  • Also check your MDAC Version on the SQL Server machine.  We had out brilliant IT Team push out new security patches that include MDAC Changes.  Well - All linked servers went down - for Oracle.  I don't know the exact changes they made to fix the issue, but they had Microsoft on the telephone and made some registry changes.  htwh, 

  • I had awful trouble once trying to just understand the myriad of things to do with Oracle - client had an app with it that we had to work with from SQL. 

    But... A quick google search found several very good and detailed tutorials on how to connect to an Oracle 9i database - I imagine the same will work for you.  One that I found easily even spoke about the pros and cons of using MS' oracle OLE DB driver vs the one from Oracle and also if you should use OLEDB -> ODBC -> Oracle or just OLEDB->Oracle.

    Can you connect using the test database login that is on Oracle servers (or at least the couple I have encountered) called "scotty"?

  • After a day with the error...

    Error 7399: OLE DB provider 'MSDAORA' reported an error.

    OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005: ].

    ...it turned out that due to trying to install oracle on a different drive to the default one shown in the installer, Oracle had hard-coded it's own paths to certain folders, leading to various registry entries pointing to the [oracle] folder on both C and D drives. As there was only one oracle folder - on the C drive - setting the [D:\oracle] registry entries back to [c:\oracle] and restarting the SQLServer allowed us to get past this error.

    Thanks to the following article which gave us the place to look:

    http://mobeen.spaces.live.com/blog/cns!C7EE59ADAEED6598!153.entry

    Hope this post helps someone... 🙂

Viewing 6 posts - 1 through 5 (of 5 total)

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