Cloud Wanderer

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.


0 Kudos