From: fvanbortel@netscape.net   
      
   Search wrote:   
      
   > I have oracle 8.1.7.   
   > the tnsnames.ora is ok .   
   > With the connect function I can connect to the remote database.   
   > BUT when I use the create database link command then it goes wrong.   
   >   
   > I can create the database link but when I try a simple select * from   
   > ...@databaselink , I   
   > recieve following error : tns servicename could not be resolved.   
   >   
   > But that is not true because I configured the tnsnames.ora well and that   
   > works.   
   >   
   > Could it be the the database link uses another file then tnsnames.ora ?   
   >   
   > How could I fix this problem?   
   >   
   >   
   > rgds   
   >   
   >   
   > Gerry   
   >   
   >   
   >   
   Your tnsnames is NOT ok - you are looking at the wrong   
   one (assumption made - not enough details).   
   Check your tnsnames on the SERVER, not the client   
      
   --   
      
   Regards,   
   Frank van Bortel   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)