+5I 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.
Best answer by Pyae
I found below one (Connect directly) in the connection strings website and it works for me. This is connecting to the Oracle Cloud.
+11Do you have the Oracle client installed on all WFEs and APP servers?
Cheers,
Vadim
+5Hi Vadim,
Yes, Oracle client is installed in WFE only. Does it require to install in App Server?
Thanks,
Pyae
+5I found below one (Connect directly) in the connection strings website and it works for me. This is connecting to the Oracle Cloud.
+11Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.