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.