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.