DB Connection Error

database
packages

#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