System.Data.OracleClient requires Oracle client software version 8.1.7 or greater (URGENT)

When I try to connect Oracle 10g db from windows 2003 server I get
error "System.Data.OracleClient requires Oracle client software version
8.1.7 or greater"

On the Windows 2003 Server
- .NET Framework 1.1
- Oracle 10g Client (I can connect with SqlPlus)

I give privilege to Users,ASPNET group and others, it doesn't work. At
least I gave privilege ASP.NET as Administrator but it still doesn't
work!
I wrote a test windows application that connect to Oracle db with
oracleclient but IT DOESN'T WORK ON THE WINDOWS 2003 SERVER. So I think
It is not a security problem.

On the windows 2003 server System.Data.OracleClient.dll v1.1.4322.2032
On my local XP System.Data.OracleClient.dll
v1.1.4322.2300

My two week is gone to solve this problem. I am sure it is not a
security problem.

Frans
Fri Aug 25 04:05:16 CDT 2006

ozcankanbur@yahoo.com wrote:

> When I try to connect Oracle 10g db from windows 2003 server I get
> error "System.Data.OracleClient requires Oracle client software
> version 8.1.7 or greater"
>
> On the Windows 2003 Server
> - .NET Framework 1.1
> - Oracle 10g Client (I can connect with SqlPlus)
>
> I give privilege to Users,ASPNET group and others, it doesn't work. At
> least I gave privilege ASP.NET as Administrator but it still doesn't
> work!
> I wrote a test windows application that connect to Oracle db with
> oracleclient but IT DOESN'T WORK ON THE WINDOWS 2003 SERVER. So I
> think It is not a security problem.
>
> On the windows 2003 server System.Data.OracleClient.dll v1.1.4322.2032
> On my local XP System.Data.OracleClient.dll
> v1.1.4322.2300

Do you have multiple Oracle clients installed on your machine? If so,
did you set the Oracle 10g client's home as the default home?

FB

--
------------------------------------------------------------------------
Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
LLBLGen Pro website: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------

ozcankanbur
Fri Aug 25 05:23:49 CDT 2006

no. Just one Oracle 10g client installed.I checked from registry.
I think the problem depends on System.Data.OracleClient version.
OracleClient version on the Windows 2003 server bigger than XP that my
developing machine.

Frans Bouma [C# MVP] yazdi:
> ozcankanbur@yahoo.com wrote:
>
> > When I try to connect Oracle 10g db from windows 2003 server I get
> > error "System.Data.OracleClient requires Oracle client software
> > version 8.1.7 or greater"
> >
> > On the Windows 2003 Server
> > - .NET Framework 1.1
> > - Oracle 10g Client (I can connect with SqlPlus)
> >
> > I give privilege to Users,ASPNET group and others, it doesn't work. At
> > least I gave privilege ASP.NET as Administrator but it still doesn't
> > work!
> > I wrote a test windows application that connect to Oracle db with
> > oracleclient but IT DOESN'T WORK ON THE WINDOWS 2003 SERVER. So I
> > think It is not a security problem.
> >
> > On the windows 2003 server System.Data.OracleClient.dll v1.1.4322.2032
> > On my local XP System.Data.OracleClient.dll
> > v1.1.4322.2300
>
> Do you have multiple Oracle clients installed on your machine? If so,
> did you set the Oracle 10g client's home as the default home?
>
> FB
>
> --
> ------------------------------------------------------------------------
> Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
> LLBLGen Pro website: http://www.llblgen.com
> My .NET blog: http://weblogs.asp.net/fbouma
> Microsoft MVP (C#)
> ------------------------------------------------------------------------