Last post Sep 04, 2012 10:39 AM by balthazarl
Nov 16, 2006 07:48 AM|yewmeng|LINK
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
Dec 05, 2006 04:26 AM|MAHBOOB123|LINK
it requires Oracle10g Release 2 ODAC 10.2.0.2.20 to be installed on the Application server. Try it out .
Dec 05, 2006 06:03 AM|Dejan Vesic|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.
Apr 18, 2007 01:12 PM|Basaveswari|LINK
May 02, 2007 10:29 PM|dcpennington2|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?
May 08, 2007 05:07 PM|hughy|LINK
Jun 01, 2007 10:23 PM|jfmccarthy|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.
Jun 19, 2007 10:42 AM|oursky|LINK
Oct 18, 2007 03:10 AM|tata32|LINK
try ODPdotNet as db driver instead of other db drivers
May 21, 2008 12:05 AMfirstname.lastname@example.org|LINK
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
Sep 24, 2008 10:35 AM|bagera|LINK
hello every body, just i need to know how i will go to this path "* Start Window Explorer and navigate to the ORACLE_HOME folder. " cause on my Machine there is no Oracle_home can any one give me the path.
that means i opened window explorer then what i will type ....
Sep 24, 2008 10:45 AM|bagera|LINK
thanks guys i found it its from "folder option" the problem with simple file sharing it must be unchecked
Oct 31, 2008 04:07 AM|madre|LINK
Hi, I had the same problem and solved it by changing the security setting as described but with one further step. On the Advanced tab check Replace permission entries on all child objects with entries shown here that apply to child objects. Then reset iis.
YAY it worked at last.
Apr 10, 2009 11:29 AM|vsurana|LINK
I am facing great problem with Oracle and ASP.Net tried a lot but could not sort out the problem
anyways just want to know that On my Pc I haev installed Oracle10g and Asp.Net 2.0 and Windows Xp
I am able to connect to Oracle Server and have sysDba rights.
Should I have to give permission on my PC or on server.
I tried a lot on giving permission to OraNT Folder, but there is no Security as its only on server.
So Do i have to give Permissions on Oracle Server.
and also Do I have to Install IIS on Oracle Server.
Please Reply as soon as possible
Thanks in Advance.
connection Problem oracle and Asp.net
oracle 10g provider for ASP.Net 2.0 Data Access
Apr 10, 2009 12:09 PM|suresh_g_v2002|LINK
For furthere reference which would help others
Suresh Kumar Goudampally
Apr 11, 2009 12:12 PM|vsurana|LINK
Does ASP.net 2.0 support connectivity to Oracle 8.0 version ?
Apr 13, 2009 06:09 AM|suresh_g_v2002|LINK
It supports ,
Use System.Data.OracleClient to connect to oracle 8.0
Apr 14, 2009 04:45 AM|vsurana|LINK
thanks for the reply
I already tried giving Read&Execute permission to Authenticated Users
Group and Internet Users on the Oracle Server and reboot the server .
Uninstall and Installed the Oracle on my PC. still problem exists
But that did't work either.
Please its urgent.
I have just hanged up with this problem.
Please please what to do ?
Apr 14, 2009 05:12 AM|vsurana|LINK
Do I have to Install any Component or dll on the server for Oracle to work with Asp.net
Is IIS necessary to present on server .
Apr 14, 2009 07:14 AM|Dejan Vesic|LINK
In order to work with Oracle in ASP.NET, you need to:
1. Install Oracle on machine which will be database server
That is it - nothing more on this server
On machine which will run your application (if this is not same as machine (1)) you need to install:
2.1 IIS (if it is not installed already)
2.2 .Net Framework of appropriate version (2.0, 3.0, 3.5 or all) - version depends on which Framework you develop application
2.3 Appropriate Oracle client with Oracle OLEDB layer (usualy called Oracle Data Access Components - ODAC)
You also need to install (2.3) on your development machine where you installed Visual Studio.
Hope this helps.
oracle installation oracle-client
Apr 14, 2009 08:01 AM|wmec|LINK
Are you able to connect to your Oracle DB using your Orale client. Try to use 10g client instead.
Apr 22, 2009 06:34 PM|djuj|LINK
Thank you Dejan.
This fixed the issue for me.
I am using Oracle 10g, with WCF service.
May 27, 2009 05:21 AM|vsurana|LINK
That Solved my problem really thanks.
Now its creating other problem
I am trying to connect Oracle 10g with ASp.net Crystal Reports but its not connecting and showing error "Tns could not resolve ..."
But it is connecting to Forms and all ,other all things are working fine
Please let me know how can I connect Crystal reports with Oracle
May 27, 2009 05:35 AM|wmec|LINK
You can check if your ODBC is working fine against your Oracle DB.
Sep 07, 2009 09:50 AM|ioriyagami|LINK
To others out there who are looking for the solution to System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. , i tried various solution i found on google including changing user permissions, reinstalling oracle 10g, and other
stuff.. but at the end I found out the solution myself by looking at the difference between my two computers (one is working, the other had this error)
if you tried other methods and still can't fix this problem, the easy but often overlooked problem that could have caused this error is:
Go to Start > Control Panels > System > Advanced tab > Environment Variables
look under System Variables.. There's a variable called 'Path' .. double click on it to edit it. See if there's a path to your oracle_home directory's Bin folder.. if it's not, congratulations, you just have to manually add in the path and the error will
be gone :)
For example my oracle_home directory is C:\oracle\10.2\ , the bin folder will be C:\oracle\10.2\bin\
So what I do is I edit the Path variable and add in C:\oracle\10.2\bin; at the very front of the line of the variable value column (ps: the semicolon seperates each variables so that they can all be in one line)
Viola, problem solved for my case.. i don't know why on one of my computer oracle installation automatically modifies the Path variable but on the other computer it doesn't... took me 2 weeks to search for the solution in google but couldn't find anyone
that mentions this.
Sep 07, 2009 10:02 AM|deryaoktay|LINK
We resolved the problem as follows:
1- defined ORACLE_HOME environment parameter
3- reboot the machine.
It did not work if you did not reboot, I donot know why.
Sep 22, 2009 03:14 PM|Wanaco|LINK
Is it possible to embed the "Oracle Instant Client" into the web application (let's say as a reference in the /bin folder) so we would not need to install the full client into the web server?
Oct 26, 2009 05:29 PM|TheBigBull|LINK
This link was perfect. I was having the same issue, Windows 7 + VS2008 + Oracle 10G Client combination on my machine. Error on trying to access oracle I got this error "System.Data.OracleClient requires Oracle client software version 8.1.7 or greater."
The fix was to visit
http://www.oracle.com/technology/software/tech/windows/odpnet/utilsoft.html and download/setup
ODAC1020221.exe 206 MB (216,841,603 bytes)
Thanks a lot.
Sep 04, 2012 10:39 AM|balthazarl|LINK
I had the same problème, I solved it by installing Oracle Client "as an administrator".