I have an Oracle 8i database that I have to access via .Net (C#) So is there
a ODP.Net provider for Oracle 8i or can I use Oracle 9i Release 2 Data
Provider for .NET 9.2.0.4.0 to access the database?

I have d\l the above .net provider and installed it and it is throwing the
well known error when attempting to connect to the Oracle 8i database.

ORA-12154: TNS:could not resolve service name

Am I better off using the MS provided Oracle provider or will this have a
similar problem?

So I checked the tnsname file and it has the relevant entry but still it
fails, oh this is a winforms app not a web app I will cross that priviledge
bridge when I come to that.....

Oracle every wondered why developers like MS IDE and database
connectivity.......

Cheers

Ollie Riches

DOH - I have found the System.Data.OracleClient is installed by default in
1.1

But stilll getting that lovely error.....


Ollie Riches

"Ollie" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I have an Oracle 8i database that I have to access via .Net (C#) So is
there
> a ODP.Net provider for Oracle 8i or can I use Oracle 9i Release 2 Data
> Provider for .NET 9.2.0.4.0 to access the database?
>
> I have d\l the above .net provider and installed it and it is throwing the
> well known error when attempting to connect to the Oracle 8i database.
>
> ORA-12154: TNS:could not resolve service name
>
> Am I better off using the MS provided Oracle provider or will this have a
> similar problem?
>
> So I checked the tnsname file and it has the relevant entry but still it
> fails, oh this is a winforms app not a web app I will cross that
priviledge
> bridge when I come to that.....
>
> Oracle every wondered why developers like MS IDE and database
> connectivity.......
>
> Cheers
>
> Ollie Riches
>
>

A 12154 is most often caused by a configuration error, though I have
observed it start occurring under extremely heavy load on an otherwise well
functioning system. Try this FAQ entry:
http://www.orafaq.com/error/ora-12154.htm

--
Michael D. Long
Microsoft MVP - Windows SDK

"Ollie" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have an Oracle 8i database that I have to access via .Net (C#) So is
>there
> a ODP.Net provider for Oracle 8i or can I use Oracle 9i Release 2 Data
> Provider for .NET 9.2.0.4.0 to access the database?
>
> I have d\l the above .net provider and installed it and it is throwing the
> well known error when attempting to connect to the Oracle 8i database.
>
> ORA-12154: TNS:could not resolve service name
>
> Am I better off using the MS provided Oracle provider or will this have a
> similar problem?
>
> So I checked the tnsname file and it has the relevant entry but still it
> fails, oh this is a winforms app not a web app I will cross that
> priviledge
> bridge when I come to that.....
>
> Oracle every wondered why developers like MS IDE and database
> connectivity.......
>
> Cheers
>
> Ollie Riches
>
>

cheers for the info and link Michael, you wre right it was a configuration
issue.

Ollie Riches

"Michael D. Long" <michael.d.long-(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> A 12154 is most often caused by a configuration error, though I have
> observed it start occurring under extremely heavy load on an otherwise
well
> functioning system. Try this FAQ entry:
> http://www.orafaq.com/error/ora-12154.htm
>
> --
> Michael D. Long
> Microsoft MVP - Windows SDK
>
> "Ollie" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> >I have an Oracle 8i database that I have to access via .Net (C#) So is
> >there
> > a ODP.Net provider for Oracle 8i or can I use Oracle 9i Release 2 Data
> > Provider for .NET 9.2.0.4.0 to access the database?
> >
> > I have d\l the above .net provider and installed it and it is throwing
the
> > well known error when attempting to connect to the Oracle 8i database.
> >
> > ORA-12154: TNS:could not resolve service name
> >
> > Am I better off using the MS provided Oracle provider or will this have
a
> > similar problem?
> >
> > So I checked the tnsname file and it has the relevant entry but still it
> > fails, oh this is a winforms app not a web app I will cross that
> > priviledge
> > bridge when I come to that.....
> >
> > Oracle every wondered why developers like MS IDE and database
> > connectivity.......
> >
> > Cheers
> >
> > Ollie Riches
> >
> >
>
>