Re: weird ORA-12514 error

Hi,

Do you have Oracle Client installed in your PC?

This error happens more often when:

1-. Your TNSNAMES.ORA file does not contain the appropriate

      SID configured. Find this file in %ORACLE_HOME%\network\admin.

2-. You have more than one Oracle home in your PC and the one

      (default) being activated by your app happens #1 above.

3-. The listener service of the server is indeed down ... try

      tnsping <SERVICE_NAME> in command line it will
      tell you even which Oracle home and parameter file
      TNSNAMES.ORA is being used.

If you get this kind of error means your application most likely uses the OCI driver and not the Thin driver which has less deployment requirements ... but don't know if Thin driver is available for C# as it is for java (classes12.jar).

HTH,
Best Regards,
Giovanni

<sunny076_at_yahoo.com> wrote in message
news:1115159227.291469.178750_at_o13g2000cwo.googlegroups.com...
> Hi,
>
> I am having a puzzling problem with connection to Oracle 9i. I
> developed a code in C# but when I tried to connect to a database, it
> gave me error "ORA-12514: TNS: listener could not resove SERVICE_NAME
> given in connect descriptor" But on the same machine I can connect and
> execute Oracle SQL without any error.
>
> I don't know what is wrong?
>
> Sunny
>
Received on Tue May 03 2005 - 13:45:38 CDT