how to create a dblink from oracle to sql server

[baig]

Hi,

I am trying to create a dblink to access a sql server from oracle.

I have configured dblinks successfully from oracle to oracle database.

i have created the db link with below pattern

==> MSSQL=
        (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.54)(PORT=1433))
            (CONNECT_DATA=
                      (SID=mypdssql)  ===> THIS SID SHOULD BE FOR THE TARGET SQL DATABASE?
            )
                        (HS=OK)
          )

please suggest.

also when i am trying to tnsping the sql server from oracle it throws the following error.
[oratest@hopdb1 ABC_hopdb1]$ tnsping MSSSQL

TNS Ping Utility for Linux: Version 12.1.0.2.0 - Production on 22-DEC-2020 16:02:37

Copyright (c) 1997, 2014, Oracle.  All rights reserved.

Used parameter files:
/u01/ABC/db/tech_st/12.1.0/dbhome_1/network/admin/ABC_hopdb1/sqlnet_ifile.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.54)(PORT=1433)) (CONNECT_DATA= (SID=mypdssql)))
TNS-12537: TNS:connection closed

[ErmanArslansOracleBlog]

Please read the following blog post ->

https://ermanarslan.blogspot.com/2016/01/rdbms-oracle-to-sqlserver-dblink.html

I have already done this kind of a setup years ago, and documented it in that blog post.

Review it.. If you still can't fix your problem, update me again.

[baig]

Hi,

ok i will try and update you.

Thanks

[sri8580]

Hi..

Really thanks for ur valuable information - It helped me a lot

Regards,
Srija,
Oracle Developer