Linked Server Trouble to Oracle

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • tim.pascoe@cciw.ca
    #1

    Linked Server Trouble to Oracle

    I'm currently trying to establish a linked server to an Oracle
    database.

    Setup:
    Connecting to 8x version of Oracle
    Using 9i client tools (Net Manager)
    SQL-Server 2000
    Windows 2000

    I installed the Oracle 9i client tools, and set up a Service for the
    Oracle connection. Testing from the 9i client produces a successfull
    connection.

    I then opened SQL-Server and created a new Linked Server with the
    following setup:

    Name - PYR_Link
    Provider - Microsoft OLE DB Provider for Oracle
    Product Name - PYR
    Data Source - PYR (9i Service Name)
    Provider string - MSDAORA

    I get the unspecific 7399 error that OLE DB provider MSDAORA reported
    an error, trace 'Initialize returned 0x80004005'

    I've searched through the archives, checked all of the relevant
    Microsoft articles I could find, and still have no idea what is wrong.
    SQL-Server reports that the provider is registered in the system, but I
    can't figure out what I'm missing.

    Help or a guide for troubleshooting would be much appreciated.

    Tim

    Tags: None
    • tim.pascoe@cciw.ca
      #2
      Re: Linked Server Trouble to Oracle

      An update - When I run sp_catalog in Query Analyzer, the error message
      is more detailed. It says the provider could nor resolve the service
      name. Still strange, considering the Net Manager client connects fine.

        Comment

        • Maurits
          #3
          Re: Linked Server Trouble to Oracle

          Hi Tim, this error could occur when the oracle domain is not recognised.

          Try to find out the Oracle domain (e.g. 'world') and change your linked
          server to connect to that domain, like product name PYR.world and data
          source PYR.world.

          Good luck!
          Maurits


          <tim.pascoe@cci w.ca> schreef in bericht
          news:1123770210 .158827.38320@g 47g2000cwa.goog legroups.com...[color=blue]
          > I'm currently trying to establish a linked server to an Oracle
          > database.
          >
          > Setup:
          > Connecting to 8x version of Oracle
          > Using 9i client tools (Net Manager)
          > SQL-Server 2000
          > Windows 2000
          >
          > I installed the Oracle 9i client tools, and set up a Service for the
          > Oracle connection. Testing from the 9i client produces a successfull
          > connection.
          >
          > I then opened SQL-Server and created a new Linked Server with the
          > following setup:
          >
          > Name - PYR_Link
          > Provider - Microsoft OLE DB Provider for Oracle
          > Product Name - PYR
          > Data Source - PYR (9i Service Name)
          > Provider string - MSDAORA
          >
          > I get the unspecific 7399 error that OLE DB provider MSDAORA reported
          > an error, trace 'Initialize returned 0x80004005'
          >
          > I've searched through the archives, checked all of the relevant
          > Microsoft articles I could find, and still have no idea what is wrong.
          > SQL-Server reports that the provider is registered in the system, but I
          > can't figure out what I'm missing.
          >
          > Help or a guide for troubleshooting would be much appreciated.
          >
          > Tim
          >[/color]


            Comment

            Previous template Next
            Working...