Publishing on Alteryx Server as an Analytics App - Data Source not found

Hi Team,

I have a workflow and I have made it into an Analytic App where it reads the following inputs from the end user:

1) Input file locations

2) Password for the Input access db (one of my input file is a password enabled Access DB and I use an create an ODBC Connection to connect to it)

3) Output folder location

This runs fine locally in my desktop. When I try to publish this to the Company's Alteryx Server, I get the below errors. Please can someone help with this.

Thanks in advance!

AlteryxServer Error.jpg

Publish

Settings

Error Message

Server

Database Connection

Accepted answers

JoeS

Hi @svimal

It looks like your server doesn't have the access database engine installed.

Are you able to remote onto the server and check?

All comments

JoeS

Hi @svimal

It looks like your server doesn't have the access database engine installed.

Are you able to remote onto the server and check?

svimal

Hi Joe,

Thank you for the response. Installing the Access drivers on the server resolved the issue.

Thanks,

svimal

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703