DB Connection Error

Help
1

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”

Please provide some suggestions

2

install latest version of oracle client , it should version of 8.1.7or above.

or try to install oracle 12c it gives better results

3

I am using SQL developer as client , version is 4.1.2.
So can i use SQL developer of higher version?

4

i dont think so, anyway try once otherwise install oracle 12c

5

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

6

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

So all you need is an Oracle Client installed. I’ve tested this using the ODAC 12.2c Release 1 and Oracle Developer Tools for Visual Studio (12.2.0.1.1) from here Oracle Data Access Components (ODAC) for Windows Downloads

1 Like