COnnectin to sqlserver from oracle
Posted on 2011-02-16
I am trying to connect sqlserver from Oracle using HS gateways. I configured listener,tnsnames.ora successfullyl Listerner also started succcessfuly
After that I created database link in Oracle , but when i am trying to connect to sqlserver from oracle, i am getting following error:
ORA_12154: TNS: COULD NOT RESOLVE THE cONNECT IDENTIFIER SPECIFIED
Please help me to fix this issue. Its very urgent
I installed ORACLE HS gateway software on the machine where oracle client is installed and also on the same machine itself is Sqlserver database server.