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

Home -> Community -> Usenet -> c.d.o.server -> Unable to connect through application

Unable to connect through application

From: Jeevan <jeevan.bordoloi_at_ocwen.com>
Date: 23 Feb 2006 07:47:34 -0800
Message-ID: <1140709653.951293.66110@z14g2000cwz.googlegroups.com>


Hi all,

I have installed Oracle 9i client on Windows Server 2003, and able to work with SQL Plus. But when I try to connect to the database programmatically, (I am using Microsoft Oracle .NET Data Provider with the connection string "Data Source='dev1';User ID='myuser';Password='mypswd';Connection Lifetime='1'") I am getting the following error message:
Error while trying to retrieve text for error ORA-12154

My TNSNAMES.ORA entries are:
dev1 =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = MyHost)(PORT = 1521))     )
(CONNECT_DATA =

      (SERVICE_NAME = matrixdev)
    )
  )

My SQLNET.ORA entries are:
SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) #names.default_domain = corporate.occ.com

Can anyone kindly help?

Regards,
Jeevan Received on Thu Feb 23 2006 - 09:47:34 CST

Original text of this message

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