Can we create db link from oracle to sql server without configuring the oracle gateway...
Someone were suggesting that we can create the db link without using any oracle gateway with only adding
(HS=OK) in the (CONNECT_DATA =(SERVICE_NAME = SWCUSTOM_PROD))(hs=ok)) of the connection description string.
EdStevens Messages: 1376 Registered: September 2013
Senior Member
azmi_aj wrote on Thu, 25 April 2019 04:02
Dear all,
Can we create db link from oracle to sql server without configuring the oracle gateway...
Someone were suggesting that we can create the db link without using any oracle gateway with only adding
(HS=OK) in the (CONNECT_DATA =(SERVICE_NAME = SWCUSTOM_PROD))(hs=ok)) of the connection description string.
Rgds
Azmi
"Someone were suggesting"
And who is that "someone"?
BTW, aside from any gateway issues, in any db link definition, you do not have to put the connection string in the link definition itself. you can define the link with just a net service name, to be resolved from the tnsnames.ora file.
BlackSwan Messages: 26766 Registered: January 2009 Location: SoCal
Senior Member
azmi_aj wrote on Thu, 25 April 2019 18:21
Thanks Ed.... for the confirmation and the link for the explaination. I just need to confirm that we still need the configure the gateway.
Rgds,
Azmi ...
Either it works or it does not work.
You should not require anything from here to verify working functionality.
Simply test & see what happens.
Error is Oracle's to indicate that a problem exists.
] 
Blog
Search
Help
Members
Register
Login
Home
