Oracle to SQL Server Connection
Hi,
A little while ago I followed the article below to successfully create an Oracle to SQL Server connection.
http://www.dbasupport.com/oracle/ora...ection01.shtml
I know have to create a second connection (on the same server). I followed the steps again, but am not able to select records.
The error I get is:
ora-12154: TNS: could not resolve connect identifier
I have checked my Listener.ora and tnsnames.ora files and they are correct. I can start the new listener and tnsping to the new connection.
I also have 2 init......ora files (initSQLSERV.ora & initNEW.ora)
Can there be 2 init.....ora files?
I also have 2 database links.
My DSN are also set up as recommeneded by the article. And get a successful connection.
Any help on having multiple Oracle to SQL Server connections would be helpful.
Many thanks in advance.
Connectivity from Sql server side easier
I noticed that using "Linked Server" which connects from the Microsoft end is an easier to setup and use link. However, in this case the link is from the Sql server end and you will be able to query oracle tables there and not vice versa.
I am an Oracle fan, but think about it, why make all this fuss of manual changes in listener/tnsnames and activation of HS (Heterogenous Services) features instead of doing it at the click of a button. My guess is that they should be including this in the latest OEM version in lines similar to the Linked Server in Microsoft.