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