Re: Right password -> ORA-12154: TNS:Could not resolve service name
From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: Tue, 02 Sep 2003 09:45:53 -0400
Message-ID: <3313343.1062510353_at_dbforums.com>
Date: Tue, 02 Sep 2003 09:45:53 -0400
Message-ID: <3313343.1062510353_at_dbforums.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.
>
>
> 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.comReceived on Tue Sep 02 2003 - 15:45:53 CEST