Getting issue while connecting to oracle database(DBCS)

Help
, , ,
1

I am getting below error while trying to connect to Oracle database(DBCS) through uipath:
Connect: ORA-28040: No matching authentication protocol

I am using below connection string:
“Server=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=150.136.240.142)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=dftedev_pdb1.dftepublicsubne.dftevcn.oraclevcn.com)));Uid=;Pwd=;”
and below provider name:
“System.Data.OracleClient”

2

Hi Priharti,

I am lao getting same error. If you got the solution please let me know.

Regards,
krishna.b

3

Hi, welcome to the community!
This is more a Oracle question than UiPath, check this:
Open the sqlnet.ora config file and see if you have something like this:

SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8

4

Hi bcorrea,

I am able to connect manually from Oracle SQL developer tool. but failed whilw i am connecting from Uipath DBconnect activity.

Let me know your thoughts.

Thanks & Regards,
krishna.b

5

What are you selecting as data provider to connect to oracle from UiPath?

6

it is System.Data.OracleClient

7

can you try with ODBC?

8

Hi, I am getting this error.
image

9

If you have the 32 bits oracle client installed with the odbc driver, you should see it as an option to select on the wizard.