Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Sep 04, 2012 09:39 AM by balthazarl
Nov 16, 2006 06:48 AM|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 03:26 AM|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 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.
Apr 18, 2007 12:12 PM|LINK
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?
May 08, 2007 04:07 PM|LINK
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.
Jun 19, 2007 09:42 AM|LINK
Oct 18, 2007 02:10 AM|LINK
try ODPdotNet as db driver instead of other db drivers
May 20, 2008 11:05 PM|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