I'm trying to connect with oracl data base and execute querry from uipath but i got this error

[yash_p]

Execute Query: Value cannot be null.
Parameter name: At least one of the connections must be used.
i used this connection string
"Data Source=(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=132.0.)(PORT=1521)));Uid=;Pwd=;”

[fernando_zuluaga]

hey

are you using the ODBC connection for this?

regards

[yash_p]

yes, I installed the odbc data source for oracle.
and for provider name i used “System.Data.OracleClient”

[suraj.setty]

Hi @yash_p

Try using Connect activity and pass the below parameters to check if the connection is established.

Thanks.

[shreyash_shirbhate]

@yash_p,

Click on configure connection and try to give the details over there and then test the connection.

at last it will automatically create the connection string.

Loading Data via an ODBC Connection

[yash_p]

[suraj.setty]

Hi @yash_p

Try passing the OutPut of the "Connect " activity as the Input for “Execute Query” Activity in “Existing Connection”

Thanks.

[yash_p]

In connection i got test connection successful message then i passed the output variable to execute query section in Existing connection.

[suraj.setty]

Please check the parameters supplied is correct or the required parameters are missing in the Edit Query Parameters of “Execute Query” Activity.

Thanks.

[AKM_Robinuzzaman (Robin Zaman)]

@yash_p Hello, Could you please check the query in the workbench first to see if thats working fine or not?

[yash_p]

Yes , I’m using select query that is working fine on oracle sql developer same i copied to uipath but it is througing error.

[yash_p]

1.After entering details on choose data source.
2. This string is genrated automatically.
“USER ID=****;PASSWORD=**;DATA SOURCE="(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 132.0.)(PORT = 1521)))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = ****)))”"

3. In expression editor it shows error sign

[yash_p]

hi robin can you tell me which odbc driver we need for connection 32 bit or 64 bit. Which is suitable for uipath

[AKM_Robinuzzaman (Robin Zaman)]

Hello @yash_p, Please go though the below post:

How to setup a connection to Oracle Database with UiPath

I don’t have a oracle server running in my machine. I am trying to connect to Oracle server hosted under a given ip. I could create a DSN. But when I test the connection, um getting below error. Unable to connect SQLState=08004[Oracle][Odbc][Ora]ORA-12154:TNS: could not resolve the connect identifier specified

However, I think that the problem is with the query not with the connection.

Regards,
Robin

[yash_p]

In this it is showing that use only 32 bit but in my machine it is showing only 64 bit is available.

Is uipath studio is 32 bit ?

[yash_p]

Hi my connection established successfully to oracle but at the time of execution it takes time and show this error message

[yash_p]

I’m Connected using creadential :" host Name , UserID, password , Service Name ,Port " and
Provider Name “oracle.managed asccess”