Hi, I've tried to setup a connection to an azure SQL database and am getting the below error when running the workflow. Does anyone have any idea on why this may be happening?
Thanks!
Start: Designer x64: Started running at 10/11/2019 16:03:25
Info: Input Data (4): Alias translated to odbc:DRIVER={ODBC Driver 17 for SQL Server};UID=XXXXXX;PWD=XXXXXX;DATABASE=XXXXXX;SERVER=XXXXXX|||"database"."parent_table"."child_table"
Info: Input Data (4): ODBC Driver version: 03.80
Error: Input Data (4): Error SQLExecute: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cursor support is not an implemented feature for SQL Server Parallel DataWarehousing TDS endpoint.
End: Designer x64: Finished running WORKFLOW.yxmd in 1.1 seconds with 1 error
Solved! Go to Solution.
Yes! This actually worked. I set it up as ODBC
Thanks for the help!