Microsoft Oracle .NET Data Provider failure! Help!

[Bill Jones]

I have a web site that was just completed in .net using c#. There are a few

places where the website needs to access an Oracle Database to get data to

build some drop down lists for forms...etc. I build the site with Visual

InterDev on my development server and access the web pages through IE 6.0

and everything seems fine. When I do a copy project, I copy only the files

necessary to run the web site to my production server. When I try to view

the web site on my production server I get the following error occuring on

the lines containing "OracleDataAdapter.Fill(DataTable)"

System.Data.OracleClient requires Oracle client software version 8.1.7 or

greater.


My production server has release 3 of Oracle 8i install and the Microsoft

Oracle .NET Data Provider installed, along with Microsoft .NET

Framework(English) v1.0.3705.


Any ideas?


Thanks

- Bill Jones

 

[Don]

I have a web site that was just completed in .net using c#. There are a few

places where the website needs to access an Oracle Database to get data to

build some drop down lists for forms...etc. I build the site with Visual

InterDev on my development server and access the web pages through IE 6.0

and everything seems fine. When I do a copy project, I copy only the files

necessary to run the web site to my production server. When I try to view

the web site on my production server I get the following error occuring on

the lines containing "OracleDataAdapter.Fill(DataTable)"

System.Data.OracleClient requires Oracle client software version 8.1.7 or

greater.


My production server has release 3 of Oracle 8i install and the Microsoft

Oracle .NET Data Provider installed, along with Microsoft .NET

Framework(English) v1.0.3705.


Any ideas?


Thanks

- Bill Jones

I'm not clear on whether your production server has the Oracle Client
installed or just the 8i server. The System.Data.OracleClient.dll uses
the client and the client connects to the server. We keep the Oracle
servers on their own hardware and the web servers have just the Oracle
client on them.

 

[Bill Jones]

I'm not clear on whether your production server has the Oracle Client
installed or just the 8i server. The System.Data.OracleClient.dll uses
the client and the client connects to the server. We keep the Oracle
servers on their own hardware and the web servers have just the Oracle
client on them.

Oracle is on its own server, and the client is installed on the web server.

Webserver Configuration:

- Windows 2000 Server SP 2
- Oracle Client 8.1.7 Release 3
- IIS 5.0
- .Net Framework 1.0 SP 2
- Microsoft Oracle .NET Data Provider

Dev Webserver is the same.

 

[Don]

Oracle is on its own server, and the client is installed on the web server.

Webserver Configuration:

- Windows 2000 Server SP 2
- Oracle Client 8.1.7 Release 3
- IIS 5.0
- .Net Framework 1.0 SP 2
- Microsoft Oracle .NET Data Provider

Dev Webserver is the same.

So the system functions on Dev Webserver but not on Production
Webserver. If the files are the same (as seems to be the case) then
what about security settings for the user on Production vs. user on Dev?
I'm always getting bit by that one because the devusers' almost always
have complete and total access to all folders and files on the dev
machines but the new folders on the production servers almost always are
created in locked down mode and something needs to be opened up to the
web user account. If that ain't it then I'm lost.

 

[Bill Jones]

Found it!! There were 2 copies of the oci.dll on my web server. One that
installed with the .NET Oracle Data Provider and the other I'm not sure
where it came from. It was in C:\WINNT\system32\