Home » RDBMS Server » Server Administration » Create DB link from oracle 9i to SQL Server (2 merged)
Create DB link from oracle 9i to SQL Server (2 merged) [message #405840] Fri, 29 May 2009 22:14 Go to next message
achilles78
Messages: 5
Registered: January 2008
Junior Member
Hi all,
I want to create DB link from Oracle 9i (reside on Linux) to SQL server(SQL server database residing on Windows XP)?
Please tell me how to create it?
Thanks.
Re: Create DB link from oracle 9i to SQL Server [message #405842 is a reply to message #405840] Fri, 29 May 2009 22:24 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.lmgtfy.com/?q=connect+oracle+to+sql+server
Re: Create DB link from oracle 9i to SQL Server (2 merged) [message #406003 is a reply to message #405840] Mon, 01 June 2009 09:05 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
There's a good article about a closely related topic here, on this very site.

It explains how to use Oracle Heterogenous Services to connect Oracle to an Acess Db.
The only thing that needs to be done differently for SQL Server is that the ODBC data source needs to be created using the SQL Server drivers rather than the Access ones.

@blackswan - I see your post is as helpful and informative as usual - don't let those standards slip, people might think you're just Trolling.

[Updated on: Mon, 01 June 2009 09:10]

Report message to a moderator

Re: Create DB link from oracle 9i to SQL Server (2 merged) [message #406014 is a reply to message #406003] Mon, 01 June 2009 11:51 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Google is great for finding answers, isn't it. Sadly none of the first 50 hits points to orafaq, so in this case is just drives traffic away from this site...
Re: Create DB link from oracle 9i to SQL Server (2 merged) [message #406039 is a reply to message #406014] Mon, 01 June 2009 21:41 Go to previous message
achilles78
Messages: 5
Registered: January 2008
Junior Member
thank everybody! Razz
Previous Topic: error at installation of Oracle 10 Rel 2 on Windows Vista 64x
Next Topic: Problem with archive_log_format parameter in SPFILE
Goto Forum:
  


Current Time: Tue Dec 10 03:24:15 CST 2024