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.