Hi, <BR><BR>Iam trying to work with Oracle 8.0 as my backend and i am using Visual basic as the front end. When i run the application it runs fine some times but some times, I am getting an error when i run my application (ActiveX Exe). The error i get is as follows: <BR><BR>"ORA-12154: TNS:could not resolve service name" <BR><BR>Can anyone let me know why this is happening? iam able to connect to the database without any problem through PL/Sql client. But, when i try to run the application or if i try to create a connection using a ado data control (after i get the error in the main application, i tried this by opening another project), iam unable to connect again and get this error: <BR><BR>"Test connection failed because of an error in initializing provider. ORA-12154: TNS:could not resolve service name" <BR><BR>Cheers, <BR>sai. <BR>