Re: Right password -> ORA-12154: TNS:Could not resolve service name
From: kiber <member34753_at_dbforums.com>
Date: Wed, 03 Sep 2003 03:04:06 -0400
Message-ID: <3322874.1062572646_at_dbforums.com>
Date: Wed, 03 Sep 2003 03:04:06 -0400
Message-ID: <3322874.1062572646_at_dbforums.com>
Originally posted by AndreH
> hi...
>
> I've understand, that I have to add an Codeline like
>
> ADOCnn.Open "Provider=OraOLEDB.Oracle;" & _
> "Data Source=db_location;" & _
> "service_name"=ServerString from tnsnames.ora;"& _
> "User Id=*****;" & _
> "Password=*****"
>
> Did I understand you correctly?
>
> MFG AndreH
I meant that you "can return" to SID's by commenting domain part of Service_name.
So, service_name in this case is equal to SID.
-- Posted via http://dbforums.comReceived on Wed Sep 03 2003 - 09:04:06 CEST