Showing results for 
Search instead for 
Did you mean: 
Nintex Newbie

Execute SQL with ODBC Connection

I need to create workflow using "EXECUTE SQL". For this, I need to connect a database using ODBC connection.

I've already created ODBC on the Sharepoint server with the name SQL64 on ODBC 64 bit I am putting the following connection string: Provider = MSDASQL.1; Password = 123456#; Persist Security Info = True; User ID = sa; Data Source = SQL64; Initial Catalog = PPICOFPT

But it gives error:

Error testing ODBC connection.

Where is the problem.


Labels: (2)
0 Kudos