July 15, 2012 at 9:57 am
ORA: 12154 TNS: Could not resolve the connect identifier specified.
The only part that I was not sure about was the TNS Service Name as specified in the following and I chose the SERVICE_NAME initially and subsequently verified
In this dialog in the text entry box labeled TNS Service Name, type the <SERVICE_NAME> found in the tnsnames.ora file.
NoteFor example, here’s a typical path to the tnsnames.ora file: C:\oracle\product\10.1.0\Db_1\NETWORK\ADMIN. In this file there are entries similar to the following: ORCL = (..(CONNECT_DATE = (...(SERVICE_NAME = orcl)))
:
I used the same TNSNAMES.ORA and SQLNET.ORA from the 32 bit Client in SSIS and I was able to create connections to Oracle and Load Several Tables from Oracle to SQL Server.
I have created hunders of DSN's to Oracle 8, 9 & 10 Clients but it has been a few years.
Any help would be greatly appreciated.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 15, 2012 at 10:37 am
I forgot to create the TNS_NAMES Environmental Variable.
I also had to reboot before I could test the DSN.
Post Closed.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply