home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 1,281 of 2,288   
   Search to All   
   data base link   
   14 Apr 04 16:22:05   
   
   From: leeuw26@yahoo.com   
      
   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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca