Errors on connection to Azure database

[cbozarth]

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

[BrandonB · Accepted solution]

Can you try the driver listed in the Azure Database page? https://help.alteryx.com/current/DataSources/SQLDB.htm

[cbozarth]

Yes! This actually worked. I set it up as ODBC 

Thanks for the help!