Re: Right password -> ORA-12154: TNS:Could not resolve service name
From: AndreH <member37728_at_dbforums.com>
Date: Tue, 02 Sep 2003 10:45:16 -0400
Message-ID: <3313575.1062513916_at_dbforums.com>
Date: Tue, 02 Sep 2003 10:45:16 -0400
Message-ID: <3313575.1062513916_at_dbforums.com>
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
-- Posted via http://dbforums.comReceived on Tue Sep 02 2003 - 16:45:16 CEST