Solved

ODBC connection string correct format

  • 19 August 2021
  • 4 replies
  • 501 views

Badge +5

I am trying to use the execute SQL action for ODBC connection. The system DNS setup is done and tested the connection successfully in ODBC Data Source.

When I trying to test the connection in Execute SQL, it does not success and showing "Error testing ODBC connection".
This is the connection string that I use : "Driver ={Oracle in OraClient19Home1}; Dbq=Name; Uid=User; Pwd=Password;"

I would like to know, is it the right connection string format or not. Appreciate for your kind advise. Thanks.

icon

Best answer by Pyae 21 August 2021, 09:58

View original

4 replies

Userlevel 7
Badge +11

Do you have the Oracle client installed on all WFEs and APP servers?

Cheers,
Vadim

Badge +5

Hi Vadim,
Yes, Oracle client is installed in WFE only. Does it require to install in App Server?
Thanks,
Pyae

Badge +5

I found below one (Connect directly) in the connection strings website and it works for me. This is connecting to the Oracle Cloud.


Userlevel 7
Badge +11
that's awesome. I'm glad you got it working!!

Reply