Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!news-out.cwix.com!newsfeed.cwix.com!ctb-nntp1.saix.net!not-for-mail From: Billy Verreynne Newsgroups: comp.databases.oracle.server Subject: Re: ORA 12154 Date: Thu, 10 Oct 2002 11:52:57 +0200 Organization: Verreynne Software Labs Lines: 44 Message-ID: References: <95p8quop99qlgkegigvqgcn8egen4329mj@4ax.com> NNTP-Posting-Host: 198.54.202.209 Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7Bit X-Trace: ctb-nnrp2.saix.net 1034243659 15681 198.54.202.209 (10 Oct 2002 09:54:19 GMT) X-Complaints-To: abuse@saix.net NNTP-Posting-Date: 10 Oct 2002 09:54:19 GMT User-Agent: KNode/0.7.1 Xref: newsfeed1.easynews.com comp.databases.oracle.server:163701 X-Received-Date: Thu, 10 Oct 2002 02:54:15 MST (news.easynews.com) Gerald Saurugg wrote: > some more details > i use odbc to connect to oracle > when i test the odbc connection the odbc driver tells me the ORA 12154. 12154, 00000, "TNS:could not resolve service name" // *Cause: The service name specified is not defined correctly in the // TNSNAMES.ORA file. // *Action: Make the following checks and correct the error: // - Verify that a TNSNAMES.ORA file exists and is in the proper // place and accessible. See the operating system specific // manual for details on the required name and location. // - Check to see that the service name exists in one of the // TNSNAMES.ORA files and add it if necessary. // - Make sure there are no syntax errors anywhere in the file. // Particularly look for unmatched parentheses or stray characters. // Any error in a TNSNAMES.ORA file makes it unusable. See // Chapter 4 in the SQL*Net V2 Administrator's Guide. If // possible, regenerate the configuration files using the Oracle // Network Manager. > when i use this odbc settings in ms access, i can link to the database! Probably as you from MS Access you are using a different Oracle connection string or a different ODBC alias.. or even a different ODBC Oracle driver. > i can open the enterprice manager and work with the database, but when i > open sqlplus i cannot connect?! Because Enterprise Manager is using a valid TNS alias (in your TNSNAMES.ORA file), whereas you are likely using the same invalid TNS for SQL*Plus as you did for your ODBC connection. > i used the same settings on windows nt and it works, on windows 2k sp3 it > does not. Do you think it is a valid statement to say that if a green VW Jetta can do 200km/hm, a green VW Beetle should also be able to go at that speed, because both cars are green and VW? -- Billy