Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

SQL Server COnnection - Table Not FOund

josevaras
5 - Atom

Hello - I am using the below string to connect to a SQL Server db. 

 

odbc:Driver={SQL Server Native Client 11.0};Server=XXXXXXXXX,1450;DATABASE=XXXXXX;Uid=XXXXXXX;Pwd=__EncPwd1__;Trusted_Connection=no;

 

However, I keep getting an error:
Error: Output Data (5): No table chosen; Please select a Table from data source. I have no idea where to add the table name in the string.

 

Any help would be appreciated. TIA

 

PS - I have only been using Alteryx for a few months. Also, version 2018.3.4

1 REPLY 1
Qiu
21 - Polaris
21 - Polaris

@josevaras 
It looks like you did not provide any query? I am sorry if you did.

SQL.PNG

Labels
Top Solution Authors