In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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