Microsoft Oracle .NET Data Provider failure! Help!

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
Wed Sep 17 11:28:48 CDT 2003

Bill Jones wrote:

> 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
Wed Sep 17 11:53:32 CDT 2003


"Don" <Don@NoSpam.org> wrote in message
news:ua3VGjTfDHA.1200@TK2MSFTNGP09.phx.gbl...
> Bill Jones wrote:
>
> > 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.
>

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
Wed Sep 17 13:34:59 CDT 2003

Bill Jones wrote:

> "Don" <Don@NoSpam.org> wrote in message
> news:ua3VGjTfDHA.1200@TK2MSFTNGP09.phx.gbl...
>
>>Bill Jones wrote:
>>
>>
>>>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.
>>
>
>
> 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
Wed Sep 17 15:39:24 CDT 2003

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\





"Don" <Don@NoSpam.org> wrote in message
news:ufbLnpUfDHA.2328@TK2MSFTNGP09.phx.gbl...
> Bill Jones wrote:
>
> > "Don" <Don@NoSpam.org> wrote in message
> > news:ua3VGjTfDHA.1200@TK2MSFTNGP09.phx.gbl...
> >
> >>Bill Jones wrote:
> >>
> >>
> >>>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.
> >>
> >
> >
> > 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.
>