Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
SOLVED

Error SQLDriverConnect: [Microsoft][ODBC Driver Manager] Data source name not found and no

MarekRe
7 - Meteor

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!

7 REPLIES 7
atcodedog05
22 - Nova
22 - Nova

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 : )

 

 

MarekRe
7 - Meteor

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! 🙂

atcodedog05
22 - Nova
22 - Nova

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 : )

MarekRe
7 - Meteor

That is helpful, I will check with the admin. Thanks! 🙂

deeptigupta
5 - Atom

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?

Nibedita_Ghosal
5 - Atom

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?

lepome
Alteryx Alumni (Retired)

Make sure you have set up the connection as a System Connection  (a User Connection is insufficient for use on Gallery.)2023-05-22_15-35-53.png

Lisa LePome
Principal Support Engineer -- Knowledge Management Coach
Alteryx, Inc.