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 -> Re: Unable to connect through application

Re: Unable to connect through application

From: EdStevens <quetico_man_at_yahoo.com>
Date: 23 Feb 2006 12:01:41 -0800
Message-ID: <1140723897.819573.206840@g47g2000cwa.googlegroups.com>

Jeevan wrote:
> 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

Hint: take a look at the docs for NAMES.DEFAULT_DOMAIN, and how that setting (which you have commented out) interacts with your connect string when looking up a service name in tnsnames.ora Received on Thu Feb 23 2006 - 14:01:41 CST

Original text of this message

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