Hi ,
In the server I have Oracle 11g. I have SQL developer in my machine and with the help of connection string given in the RPA code I am able to connect to the DB and execute query but when I try to execute the same RPA program I am getting below error
“System.Data.OracleClient requires Oracle Client software version 8.1.7 or greater”
I cannot change Oracle version it it in server and other projects are referring the same DB.
Thanks for your help. If anybody else have idea of what is missing here please give ur suggestion.
RPA program which I have written is in my machine and i am connecting to the Oracle in the server these are connected by LAN.
Connection should be fine since I am able to execute the query via SQL Developer
Hello everyone,
The issue is caused by the fact that client is missing the Oracle Data Access Component, it has nothing to do with version of Oracle server and version of the Oracle SQL Developer.
Oracle server version you can check by running select * from v$version;
Oracle client you can check in help of SQL dev - using v. 18.4.0.376
Oracle data access you can check in the registry, should have a key similar with this Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Oracle\ODP.NET.Managed\4.122.1.0
and a key like C:\oracle\product\12.2.0\client_1\network\admin or similar