Pyae
Scout

ODBC connection string correct format

Jump to solution

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.

0 Kudos
Reply
4 Replies
vadim_tabakman
Nintex Employee
Nintex Employee

Re: ODBC connection string correct format

Jump to solution

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

Cheers,
Vadim

Reply
Pyae
Scout

Re: ODBC connection string correct format

Jump to solution

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

0 Kudos
Reply
Pyae
Scout

Re: ODBC connection string correct format

Jump to solution

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

p1.PNGp2.PNG

Reply
vadim_tabakman
Nintex Employee
Nintex Employee

Re: ODBC connection string correct format

Jump to solution
that's awesome. I'm glad you got it working!!
0 Kudos
Reply