workflow fails when it is scheduled

Dear all,

I have face an issue when i try to schedule a simple workflow that extract some data from different data bases through a odbc connector and after some transformations the data goes to an excel file output.

When I run the workflow manually it works fine. But when I set up the scheduled run it fails every single time.

I have tryed running it as a copy in scheduler DB and as a copy in my local machine, both fails.

the error messages that I'm getting are like this :

Error: Tool #133: SQLDriverConnect error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver was specified.

I'm really lost troubleshooting this errors. I really would appreciate any help

Thank you in advance.

Jorge

Scheduler

Accepted answers

All comments

Jean-Balteryx

Hi @Jmarquez ,

Have you added the data sources on the machine running Alteryx Server ?

Jmarquez

Hi @Jean-Balteryx,

I forgot to mention that I don't have the server license.

I'm setting up the process with the basic scheduler license.

Jean-Balteryx

On your computer ?

Jmarquez

yes it is

Jean-Balteryx

This post might help you : https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Data-source-name-not-found-and-no-default-driver-specified/td-p/537412

Tell me if it allows you to solve your problem.

Jmarquez

I'm still a bit lost with this,
I am running the workflow locally on my computer, where I have created the odbc connections with my username and password, the same one that is configured in the alteryx data entry.