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.
It defi has to do with settings in client machine.
Try replacing tnsnames.ora & sqlnet.ora files from client it works to client it does not work. Also compare the ODBC setting in these 2 client machine and bring them in sync.