SQL Server COnnection - Table Not FOund
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
josevaras
5 - Atom
‎03-21-2022
05:36 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Labels:
- Labels:
- Database Connection
- Server
- Settings
- Workflow
1 REPLY 1
21 - Polaris
‎03-22-2022
12:42 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@josevaras
It looks like you did not provide any query? I am sorry if you did.
![](/skins/images/A29875142F332EEF75F19ED75711F41B/responsive_peak/images/icon_anonymous_message.png)