Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Unable to connect through application
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