Home » RDBMS Server » Networking and Gateways » Connection between oracle and mssql (Oracle 11 and Mssql 2005)
icon5.gif  Connection between oracle and mssql [message #589869] Thu, 11 July 2013 08:50 Go to next message
thorin666
Messages: 142
Registered: March 2007
Senior Member

Hello, i have 2 instances (one on Oracle 11g and the otherone Mssql)
i was asked to make a link between both. (i don't know how)
btw i need excecute a procedure from Oracle against Mssql tables. Does any know how can i do something like that?
Regards!
Re: Connection between oracle and mssql [message #589870 is a reply to message #589869] Thu, 11 July 2013 08:56 Go to previous messageGo to next message
BlackSwan
Messages: 23162
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/


It depends.

which database initiates the connection to the other database?

>btw i need excecute a procedure from Oracle against Mssql tables.
in which database does the procedure physically reside?
Re: Connection between oracle and mssql [message #589871 is a reply to message #589870] Thu, 11 July 2013 09:08 Go to previous messageGo to next message
thorin666
Messages: 142
Registered: March 2007
Senior Member

Hello BlackSwan, the procedure reside on the Oracle database and the connection is initiated by Oracle. thank you you for your help!!!
Re: Connection between oracle and mssql [message #589872 is a reply to message #589871] Thu, 11 July 2013 09:13 Go to previous message
BlackSwan
Messages: 23162
Registered: January 2009
Senior Member
> the procedure reside on the Oracle database and the connection is initiated by Oracle.
How can any procedure which resides inside Oracle DB do anything against or to the content of MS SQLServer database; when no database link to other DB exists?

since it appears that GOOGLE is broken for you, please do as below

http://www.lmgtfy.com/?q=oracle+database+link+sql+server
Previous Topic: Erratic TNS behavior-errors
Next Topic: ora-12505 error with sql developer
Goto Forum:
  


Current Time: Mon Dec 22 20:43:46 CST 2014

Total time taken to generate the page: 0.10274 seconds