Re: Trying to connect oracle

"sharadgaikwad" <member_at_dbforums.com> wrote in message news:1847136.1032793596_at_dbforums.com...
>
> Hi All,
> I am tring to connect oracle 8.1.7 from my asp.net application, all the
> time i am receiving error, Error while trying to retrieve text for error
> ORA-12154.
>
> Need help.Thanks in advance.
>
> Sharad
>
> --
> Posted via http://dbforums.com
>

The oracle error is listed as:

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.

What platform? Verify the ORACLE_HOME. See that you have a tnsnames.ora file properly configured in that OH. Like Daniel said, can you connect with sqlplus? Have you tried tnsping command?

Kevin Received on Mon Sep 23 2002 - 13:50:27 CDT