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

sunny076@yahoo.com wrote:

> 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

Believe the error message and track down the problem in your code.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

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@yahoo.com> wrote in message
news:1115159227.291469.178750@o13g2000cwo.googlegr oups.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
>

On Tue, 3 May 2005 19:45:38 +0100, "Giovanni Azua"
<bravegag@hotmail.com> wrote:

>Hi,
>
>Do you have Oracle Client installed in your PC?

Please do not top post and include the entire message.


--
Sybrand Bakker, Senior Oracle DBA

> Believe the error message and track down the problem in your code.
>
Extremelly helpful!