From: rs_arwar@hotmail.com   
      
   Originally posted by AndreH   
      
   > HI....   
      
   >   
      
   > If I try to connect to a Oracle DB I get this:   
      
   >   
      
   > ORA-12154: TNS:Could not resolve service name   
      
   >   
      
   > But I know, that my username and Passwort are right.   
      
   >   
      
   > thats my connSring!!!!   
      
   >   
      
   > ADOCnn.Open "Provider=OraOLEDB.Oracle;" & _   
      
   >                 "Data Source=db_location;" & _   
      
   >                 "User Id=*****;" & _   
      
   >                 "Password=*****"   
      
   >   
      
   > Can you tell me, whether i forget someting????   
      
   >   
      
   > mfg AndreH   
      
      
      
      
      
   Refer to 2) in my previous post.   
      
      
      
   Test your connection from sqlplus. If it works then check your connect   
   string/Connection object on ADO side, if not then run netca and check   
   your Net8/9 settings or connect url.   
      
      
      
   Regards   
      
   /Rauf   
      
      
   --   
   Posted via http://dbforums.com   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)