ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

Thanks,

But I checked the path and I don't see any old client path. So it is still does not work.

Ming Man

Originally in my server I have:

c:\app\chanmm\product\11.1.0\db_1\NETWORK\ADMIN
ORCLDEMO =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = demo)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcldemo)
)
)

and I tried to change it because of the error to:

ORCLDEMO =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = demo)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(CONNECT_DATA = (SERVICE_NAME = orcldemo))
)
)

I have no problem at all when I am using VS 2005 and even VS 2008 before I install ODP.NET 11g

Mark are you around somewhere?

Ming Man

I need TNS name to work so this definitely is not the solution for me.

Thanks,
Ming Man

Thanks Mark,

for tnsnames.ora I change back to:

ORCLDEMO =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = demo)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcldemo)
)
)

For sqlnet.ora original is:

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

so I tried to comment the NAMES.DIRECTORY_PATH as:

SQLNET.AUTHENTICATION_SERVICES= (NTS)

# NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

but no luck.

Ming Man