I am using System.Data.OracleClient for database connection. It work fine when i doing development. But after i published and deployed in IIS. i get System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. I also try to search
from the internet through that error message but the solution that i get seems like not work. I am stucks, Please help
There is known bug with Oracle installer which does not setup rights on folders as expected, so IUSR_ or ASPNET machine user can't access appropriate Oracle Client DLL's.
Try to add Everyone / Read for Oracle home and all subfolders and restart IIS - this should solve problem.
System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
at System.Data.OracleClient.OCI.DetermineClientVersio n()
at System.Data.OracleClient.OracleInternalConnection. OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
at System.Data.OracleClient.OracleInternalConnection. .ctor(OracleConnectionString connectionOptions)
at System.Data.OracleClient.OracleConnectionFactory.C reateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.Creat ePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateOb ject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCrea teRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConne ction(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OracleClient.OracleConnection.Open()
at QuoteService.connStr() in c:\Inetpub\wwwroot\FirstApplBasu\App_Code\QuoteSer vice.cs:line 109
at QuoteService.InsertRec() in c:\Inetpub\wwwroot\FirstApplBasu\App_Code\QuoteSer vice.cs:line 118
To fix the above problem i have tried the Authenticated Users group privilege to the Oracle Home directory.
* Log on to Windwos as a user with Administrator privileges.
* Start Window Explorer and navigate to the ORACLE_HOME folder.
* Choose properties on the ORACLE_HOME folder.
* Click the “Security” tab of the “Properties” window.
* Click on “Authenticated Users” item in the “Name” list.
* Uncheck the “Read and Execute” box in the “Permissions” list under the “Allow” column.
* Re-check the “Read and Execute” box under the “Allow” column
* Click the “Advanced” button and in the “Permission Entries” verify that “Authenticated Users” are listed with permission = “Read & Execute”, and Apply To = “This folder, subfolders and files”. If not, edit that line and make sure that “Apply To” drop-down
box is set to “This folder, subfolders and files”. This should already be set properly but it is important that you verify it.
* Click the “Ok” button until you close out all of the security properties windows. The cursor may present the hour glass for a few seconds as it applies the permissions you just changed to all subfolders and files.
* Reboot, to assure that the changes have taken effect.
after trying them also no use im getting same error could any one help me regarding this
I was having the same issue. My problem was that the permissions were not propagating down to the bin directory. I had to explicity grant read and execute privilages to the ASPNet user on the bin directory, not just the oracle home directory.
I was having the same problem with a few projects and no matter how many permissions I changed I still got the error. I had to eventually recreate my VS websites/projects from scratch.
Life would be so much easier if we only had the source code.
I am facing the similar problem as you mentioned in the above. I am using System.Data.OracleClient for database connection. I have installed Oracle 10.1.0 client software and application is working fine on my development machine. After deployed, I am getting
error message System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. I gave Internet guest account (IUSR_) and Everyone read and execute permissions on Oracle folder. Still the same error. Appreciate if you can tell me how did you
solve this issue.
yewmeng
Member
5 Points
3 Posts
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
Nov 16, 2006 06:48 AM|LINK
Hi all,
Currenlty i am using asp .net 2.0 and oracle 10g.
My current arhitechture look like this
Server A - Oracle database 10g
Server B - Web application and Oracle 10 g client
I am using System.Data.OracleClient for database connection. It work fine when i doing development. But after i published and deployed in IIS. i get System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. I also try to search from the internet through that error message but the solution that i get seems like not work. I am stucks, Please help
Thanks a million Help
MAHBOOB123
Member
5 Points
1 Post
Re: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
Dec 05, 2006 03:26 AM|LINK
Hi,
http://www.oracle.com/technology/software/tech/windows/odpnet/index.html
it requires Oracle10g Release 2 ODAC 10.2.0.2.20 to be installed on the Application server. Try it out .
Mahboob
Dejan Vesic
Contributor
2430 Points
473 Posts
Re: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
Dec 05, 2006 05:03 AM|LINK
There is known bug with Oracle installer which does not setup rights on folders as expected, so IUSR_ or ASPNET machine user can't access appropriate Oracle Client DLL's.
Try to add Everyone / Read for Oracle home and all subfolders and restart IIS - this should solve problem.
Dejan Vesić
MCAD for .Net technologies | http://www.vesic.org/english/ | Blog: http://www.vesic.org/english/blog/
Basaveswari
Member
2 Points
1 Post
Re: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
Apr 18, 2007 12:12 PM|LINK
at System.Data.OracleClient.OCI.DetermineClientVersio n()
at System.Data.OracleClient.OracleInternalConnection. OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
at System.Data.OracleClient.OracleInternalConnection. .ctor(OracleConnectionString connectionOptions)
at System.Data.OracleClient.OracleConnectionFactory.C reateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.Creat ePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateOb ject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCrea teRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConne ction(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OracleClient.OracleConnection.Open()
at QuoteService.connStr() in c:\Inetpub\wwwroot\FirstApplBasu\App_Code\QuoteSer vice.cs:line 109
at QuoteService.InsertRec() in c:\Inetpub\wwwroot\FirstApplBasu\App_Code\QuoteSer vice.cs:line 118
To fix the above problem i have tried the Authenticated Users group privilege to the Oracle Home directory.
* Log on to Windwos as a user with Administrator privileges.
* Start Window Explorer and navigate to the ORACLE_HOME folder.
* Choose properties on the ORACLE_HOME folder.
* Click the “Security” tab of the “Properties” window.
* Click on “Authenticated Users” item in the “Name” list.
* Uncheck the “Read and Execute” box in the “Permissions” list under the “Allow” column.
* Re-check the “Read and Execute” box under the “Allow” column
* Click the “Advanced” button and in the “Permission Entries” verify that “Authenticated Users” are listed with permission = “Read & Execute”, and Apply To = “This folder, subfolders and files”. If not, edit that line and make sure that “Apply To” drop-down box is set to “This folder, subfolders and files”. This should already be set properly but it is important that you verify it.
* Click the “Ok” button until you close out all of the security properties windows. The cursor may present the hour glass for a few seconds as it applies the permissions you just changed to all subfolders and files.
* Reboot, to assure that the changes have taken effect.
after trying them also no use im getting same error could any one help me regarding this
in advance thanks,
Basaveswari
Oracle .net 2.0 Web Services VS.2005 SQLDataSource oracleconnection c#
dcpennington...
Member
225 Points
56 Posts
Re: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
May 02, 2007 09:29 PM|LINK
To either of you still having the issue, are you using mixed clients (eg: 9i / 10g), or are you purely 10g?
....and what IIS versions are you working with?
....Have you installed any Oracle-specific items that deal with data access recently?
... .Oh and do you have multiple Oracle Homes defined?
(Insert Significant Credentials and Witty Comment Here)
hughy
Member
18 Points
22 Posts
Re: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
May 08, 2007 04:07 PM|LINK
jfmccarthy
Member
644 Points
121 Posts
Re: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
Jun 01, 2007 09:23 PM|LINK
I was having the same problem with a few projects and no matter how many permissions I changed I still got the error. I had to eventually recreate my VS websites/projects from scratch.
oursky
Member
2 Points
1 Post
Re: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
Jun 19, 2007 09:42 AM|LINK
tata32
Member
4 Points
2 Posts
Re: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
Oct 18, 2007 02:10 AM|LINK
try ODPdotNet as db driver instead of other db drivers
sgunturu@gma...
Member
6 Points
3 Posts
Re: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
May 20, 2008 11:05 PM|LINK
Hi Yewmeng,
I am facing the similar problem as you mentioned in the above. I am using System.Data.OracleClient for database connection. I have installed Oracle 10.1.0 client software and application is working fine on my development machine. After deployed, I am getting error message System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. I gave Internet guest account (IUSR_) and Everyone read and execute permissions on Oracle folder. Still the same error. Appreciate if you can tell me how did you solve this issue.
Thanks a lot, Shailaja