Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> OLEDB connecting to Oracle 8.1.5
I have a problem using an ATL consumer connecting to the Oracle database.
The massage I've gotten:
Test connection failed because od an error in initializind provider.
ORA-12154: TNS could not resolve service name.
My tnsname.ora file :
...
TCI.TEAMGARRETT.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = contractor1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = tci.teamgarrett.com)
)
)
.......
I use as a server name the 'TCI.TEAMGARRETT.COM'.
The connection test using SQLNet easy is successful.
Thanks in advance,
TG Received on Mon Aug 23 1999 - 17:10:31 CDT