471,852 Members | 1,317 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,852 software developers and data experts.

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

Aug 11 '05 #1
2 4886
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.

Aug 11 '05 #2
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
<ti********@cciw.ca> schreef in bericht
news:11*********************@g47g2000cwa.googlegro ups.com...
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

Aug 15 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by Sudhesh Nayak | last post: by
3 posts views Thread by David Gray | last post: by
2 posts views Thread by Pardhasaradhy | last post: by
4 posts views Thread by arichie | last post: by
NeoPa
reply views Thread by NeoPa | last post: by
reply views Thread by YellowAndGreen | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.