Home » SQL & PL/SQL » SQL & PL/SQL » database link (r11)
database link [message #420797] Wed, 02 September 2009 05:31 Go to next message
Messages: 64
Registered: January 2009
i want to make a database link between oracle 9i and sql server 2005

Alaa Fouad

Re: database link [message #420829 is a reply to message #420797] Wed, 02 September 2009 09:31 Go to previous messageGo to next message
Messages: 25529
Registered: January 2009
Location: SoCal
Senior Member
CREATE DATABASE LINK command does not know or care about flavor of remote host; so just make it.

Have you properly licensed Heterogeneous Services?
Re: database link [message #420902 is a reply to message #420829] Thu, 03 September 2009 03:09 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
There is slightly more to it than just creating a Db link.

There's this FAQ on ORAFAQ that tells you how to connect to an Access DB.
COnnecting to an SQL Server Db works in exactly the same fashion once you've created the ODBC connection to the SQL Server DB.

If you were to use the Oracle Transparent Gateway for Sql Server, then you'd need to license it seperately, but I believe that the Oracle Generic Connectivity comes as part of the DB.


[Updated on: Thu, 03 September 2009 03:14]

Report message to a moderator

Previous Topic: Need a Query to solve this
Next Topic: Problem in accessing sequence
Goto Forum:

Current Time: Sat Jul 22 12:03:35 CDT 2017

Total time taken to generate the page: 0.12389 seconds