ORA-12154 TNS could not resolve service name

[angu]

Hai all,


I have developed an application in VB and have connected to Personal Oracle 8i through ODBC. I have given the DSN name and User Name in the ODBC connection and left the Server name blank sice it is the local server. The VB applicaton and the personal oracle are in the same PC. When my client tried to open the application, he gets the error

ORA-12154 TNS could not resolve service name. Microsoft SetConnectAttribute Failed.

But, my client is able to start up Oracle from the start menu and also login to sqlplus by giving the user name and password.

I am giving the configuration of tnsnames.ora, listener.ora and sqlnet.ora below. They seem to be correct.

*************************
tnsnames.ORA file configuration
**************************

# TNSNAMES.ORA Network Configuration File: d:\Oracle\Ora81\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.


ORACLE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = workstation8)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = Oracle)
)
)


EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

************
LISTENER.ORA
*************

# LISTENER.ORA Network Configuration File: d:\Oracle\Ora81\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = workstation8)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = workstation8)(PORT = 2481))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\Oracle\Ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = Oracle)
(ORACLE_HOME = d:\Oracle\Ora81)
(SID_NAME = Oracle)
)
)

**********
SQLNET.ORA
***********

# SQLNET.ORA Network Configuration File: d:\Oracle\Ora81\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)


Even I had asked my client to start the listener also.

But still, the same error is prevailing.

Urgent help required.

Thanks in advance.
Angu

[stecal]

http://dbasupport.com/oracle/ora9i/connecting.shtml