Error SQLDriverConnect: [Microsoft][ODBC Driver Manager] Data source name not found and no
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I have a problem with my workflow, which runs well on the Alteryx Desktop (Designer) version. However, when I published (saved as) it to the Gallery, it doesn't work with the below error:
- Error SQLDriverConnect: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (Tool Id: 1)
The workflow is connecting to DSN (Smartsheet) through ODBC connection that I set up (System DSN).
Does anyone know how to fix it?
thanks!
Solved! Go to Solution.
- Labels:
- Error Message
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @MarekRe
DSN connection set is specific to the system. Unless the DSN connection is setup on Gallery (similar to your desktop) by gallery admin workflows using DSN will not work on gallery.
An alternative is to use connection string directly instead of DSN in the input tool. And this should ideally work with no extra configuration on gallery.
Hope this helps : )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for the response @atcodedog05 !
Could you help me to understand what does it mean: to use connection string directly instead of DSN?
This is how I set up the connection: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Connecting-Alteryx-to-Smartsheet/td-p/...
Not sure if it matters, but I am using Virtual Machine on AWS for this project. Thanks again! 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @MarekRe
oh sorry, I thought it was a generic database😅. I am not much aware of smart sheets.
Then it's the first option you can check with your Gallery admin to set this DSN on the Gallery system.
Additionally, you can drop a mail to the Alteryx Tech team support@alteryx.com they might be able to provide you with more guidance.
Hope this helps : )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
That is helpful, I will check with the admin. Thanks! 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi
I'm also facing exact same issue, where DSN Connection string fails on gallery and redshift bulk loader needs DSN connection string.
are you able to solve this? If not, did you use any other workaround?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I am also facing the same issue. My workflow is throwing same error. How to do DSN connection is setup on Gallery?
Can you please share the steps?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Make sure you have set up the connection as a System Connection (a User Connection is insufficient for use on Gallery.)
Principal Support Engineer -- Knowledge Management Coach
Alteryx, Inc.
![](https://www.thekcsacademy.net/secure/KCS_v6_Fundamentals_Logos/KCSv6Fundamentals_100x100.jpg)
![](/skins/images/1A7F54316481E10DBCA4A87A32E06CC6/responsive_peak/images/icon_anonymous_message.png)