System.Data.OracleClient requires Oracle client 8.1.7 error
567010Feb 18 2010 — edited Mar 25 2011Hello all,
I have recently upgraded computers. My previous computer was Windows XP and had installed on it Oracle 9i, Oracle 10g, SQL Server 2005 and 2008, Visual Studio 2003, 2005, and 2008. I was able to create new applications and update legacy applications without problems.
My new computer is Windows 7 Ultimate and has installed Oracle 10g Express, SQL Server 2008, and Visual Studio 2008.
When I try to run my applications using Oracle (through Visual Studio or from exe) I receive the error
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater
These same applications have not been modified, and worked fine on my old system.
I have tried reinstalling Oracle 10g Express, running the install as an administrator.
The database homepage works fine, SQLPlus works ok, and I can link to the Oracle database through the Visual Studio IDE.
I have read that the error may be due to a permission problem, and so verified that the oraclexe folder has read and execute permissions.
On a possibly relevant note, the SQLPlus command path is not recognized by the system. I need run SQLPlus from C:\oraclexe\app\oracle\product\10.2.0\server\BIN\SQLPlus to get it to work. I don't know if this is a symptom of the same problem.
I'm out of ideas. Any help would be greatly appreciated.
Thank you.