Connect : System.Data.OracleClient requires Oracle client software version 8.1.7 or greater

[Yazan_Otaibi]

hi,
im trying to connect to oracle db and already download oracle client last version 12,

im facing the same error :
Connect : System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.

my connection string is :
“Server=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.0.0)(PORT=000))
(CONNECT_DATA=(SID=test)));Uid=User;Pwd=Pass;”

my provider name is :
“System.Data.OracleClient”

[Anil_G (Anil Gorthi)]

@Yazan_Otaibi

Please check this

"System.data.oracleclient requires oracle client software version 8.1.7 or greater" in UiPath.Database.Activities

How to resolve "System.data.oracleclient requires oracle client software version 8.1.7 or greater" error? Issue Description: While trying to connect or execute any queries on Oracle database server by using UiPath.Database.Activities might encounter the following error : "System.data.oracleclient requires oracle client software version 8.1.7 or greater". Resolution: The issue is caused by the fact that the authenticated user is missing the Oracle Data Access Component needed to run the pro…

Hope this helps

Cheers

[Yazan_Otaibi]

already checked and not help

[Anil_G (Anil Gorthi)]

@Yazan_Otaibi

Did you happen to change the database version and check?

Cheers

[Yazan_Otaibi]

the solution was to install both version 32 bit and 64 bit