Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> OLEDB connecting to Oracle 8.1.5

OLEDB connecting to Oracle 8.1.5

From: Bob Sterling <NOSPAM_Sterling_at_bscusa.com>
Date: Mon, 23 Aug 1999 18:10:31 -0400
Message-ID: <eCjw3.334$SC5.17023@iad-read.news.verio.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US