Re: Right password -> ORA-12154: TNS:Could not resolve service name
From: kiber <member34753_at_dbforums.com>
Date: Tue, 02 Sep 2003 10:25:29 -0400
Message-ID: <3313568.1062512729_at_dbforums.com>
Date: Tue, 02 Sep 2003 10:25:29 -0400
Message-ID: <3313568.1062512729_at_dbforums.com>
>
> ADOCnn.Open "Provider=OraOLEDB.Oracle;" & _
> "Data Source=db_location;" & _
> "User Id=*****;" & _
> "Password=*****"
>
In 9i it's service_name, not SID.
Go to %ORACLE_HOME%/network/admin/sqlnet.ora
and comment NAMES.DEFAULT_DOMAIN
Also look at your tnsnames.ora for your service.
-- Posted via http://dbforums.comReceived on Tue Sep 02 2003 - 16:25:29 CEST