Oracle Data Provider for .NET (ODP.NET)

[Ollie]

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

 

[Ollie]

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

But stilll getting that lovely error.....


Ollie Riches

 

[Michael D. Long]

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

 

[Ollie]

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

Ollie Riches