topic Re: Error SQLDriverConnect: [Microsoft][ODBC Driver Manager] Data source name not found an in Alteryx Server Discussions

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

MarekRe — Sun, 31 Oct 2021 10:02:29 GMT

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!

Re: Error SQLDriverConnect: [Microsoft][ODBC Driver Manager] Data source name not found an

atcodedog05 — Sun, 31 Oct 2021 10:25:49 GMT

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

Re: Error SQLDriverConnect: [Microsoft][ODBC Driver Manager] Data source name not found an

MarekRe — Sun, 31 Oct 2021 11:37:15 GMT

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/27150

Not sure if it matters, but I am using Virtual Machine on AWS for this project. Thanks again! 🙂

Re: Error SQLDriverConnect: [Microsoft][ODBC Driver Manager] Data source name not found an

atcodedog05 — Sun, 31 Oct 2021 11:46:01 GMT

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

Re: Error SQLDriverConnect: [Microsoft][ODBC Driver Manager] Data source name not found an

MarekRe — Sun, 31 Oct 2021 12:07:19 GMT

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

Re: Error SQLDriverConnect: [Microsoft][ODBC Driver Manager] Data source name not found an

deeptigupta — Tue, 20 Dec 2022 10:10:11 GMT

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?

Re: Error SQLDriverConnect: [Microsoft][ODBC Driver Manager] Data source name not found an

Nibedita_Ghosal — Mon, 03 Apr 2023 11:40:22 GMT

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?

Re: Error SQLDriverConnect: [Microsoft][ODBC Driver Manager] Data source name not found an

LisaL — Mon, 22 May 2023 21:37:06 GMT

Make sure you have set up the connection as a System Connection (a User Connection is insufficient for use on Gallery.)