cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle Communication: Failed to connect to server or failed to parse connect string

chauhannaman98
Level 3

Hi all,

I am using Oracle (MDA) VBO to connect with Oracle DB.

On set connection, it generates the connection string: Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST="hostname(not IP address)")(PORT=1521))(CONNECT_DATA=(SERVICE_NAME="DB name")));User Id="username";Password="passsword";

chauhannaman98_0-1712746524923.png

But, on running Get Collection action after this, it is throwing me an error: Oracle Communication: Failed to connect to server or failed to parse connect string.

I am able to connect with SQL developer and execute queries but it's failing here.

What can be done for this?

4 REPLIES 4

chauhannaman98
Level 3

Update: I tried using IP address instead of hostname in ConnectionName. It's still failing.

Hello,

Is the ODAC driver installed?

Regards,

Leonardo Soares RPA Developer América/Brazil

Hi @LeonardoSQueiroz ,

Thanks for replying!

I think I haven't installed anything like that.

How do I check and install ODAC driver on the machine?

Thanks!

 

faheemsd
MVP

Dear @chauhannaman98 

Please check with ORACLE MDA connection details with the respective db team such as connection name, hostname (Ip address) , Port number and Password.

Used those values that are available in the Oracle MDA configuration.
Test this connection with Set connection.
Requesting you to get the Oracle MDA queries from the respective team because normal SQL queries doesn't support with the ORACLE MDA SQL VBO.