Error SQLDriverConnect:Data source name not found and no default driver specified!!!

[kritika24]

While scheduling a workflow, getting an error Error SQLDriverConnect: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. but while running the workflow manually, the workflow is executed.
Thanks in advance.

[DavidSkaife · Accepted solution]

Hi @kritika24 

When you say running it manually i assume you mean running it on your local machine?

This means one of two potential issues:

That the ODBC the workflow is attempting to use is not installed on your Server, or the name of the source is different to what is on your local machine. If it is installed the name (see screenshot below) must match the source name being used in Alteryx.

[kritika24 · Accepted solution]

Hey @DavidSkaife
I checked the name at both places it was same but somehow I figured out the gap I was getting error, the driver was not added in System DSN that is the reason it was ending up in error.
Its solved now!
Thanks.

[nickdreach]

I've seen this occur when using an Output Data tool to write to a database and the insert statement includes a column that isn't in the target table 😀

[JamesArce]

how can I save involved ODBC in Server?

[DavidP]

Thank you @kritika24,

You're tip about the System DSN helped me resolve my issue. Thank you!!

[scancissu01]

I am having the same issue as described above. I created a System DSN directly in the Server Controller, however, issue persists.

It runs locally in the Controller or at the customer machine, however it fails when saving to the Gallery.

Thanks!