topic Re: Oracle Communication: Failed to connect to server or failed to parse connect string in Digital Exchange

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

chauhannaman98 — Wed, 10 Apr 2024 10:56:11 GMT

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";

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?

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

chauhannaman98 — Wed, 10 Apr 2024 15:54:45 GMT

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

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

LeonardoSQueiroz — Wed, 10 Apr 2024 18:32:55 GMT

Hello,

Is the ODAC driver installed?

Regards,

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

chauhannaman98 — Wed, 10 Apr 2024 19:22:44 GMT

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!

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

faheemsd — Mon, 15 Apr 2024 07:42:25 GMT

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.