Re: Linked Servers
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Fri, 31 Oct 2008 22:31:22 +0000 (UTC)
Dom (dolivastro@xxxxxxxxx) writes:
I posted this at SqlServer-programming group, but got no responses.
We have two servers, one MS SQL Server, the other Oracle. Sometimes I
need to get data from oracle in the MyDatabase catalog, bring it to
MSSql, and join it to other tables and proceed from there. I would like
to use LInked Servers instead.
I did the following:
exec sp_AddLinkedServer
'ORACLE'
, 'MyDatabase'
, 'MSDAORA'
, 'x.x.x.x'
Of course, "x.x.x.x" was actually the IP address of the server.
"ORACLE" appears in my Lilnked Servers list in SSMS, but I can't view
any of the tables because "The OLD EB Provider MSDAORA has not been
registered."
Funny, since MSDAORA is part of Windows, it should be there.
Then again, which version of Oracle do you use? MSDAORA is old and
dusty, and is good for Oracle 8, and maybe Oracle 9. For later versions,
you should definitely use Oracle's own provider.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Follow-Ups:
- Re: Linked Servers
- From: Dom
- Re: Linked Servers
- Prev by Date: Re: point-in-time vs. shadow tables for audit history
- Next by Date: Re: point-in-time vs. shadow tables for audit history
- Previous by thread: Re: point-in-time vs. shadow tables for audit history
- Next by thread: Re: Linked Servers
- Index(es):
Relevant Pages
|
