Re: ORA 12154

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