Error - Error opening connect string: Can't create Data Source Object
We are trying to use Alteryx scheduler to take data from an Access database, without luck.
After I installed the Microsoft Access Database Engine 2010, it worked fine.
@oliver_sayers
is the workflow running fine from the local machine ?
what option are you using when you use scheduler
from the Local disk or in the Scheduler DB?
Did you configure the ODBC at server level for MS Access?
Thanks
Saravanan
Is the access DB open in another application or is the workflow already open on another Alteryx instance?
Can you provide some clear instructions on installing Microsoft Access Database Engine 2010. Should I just download directly from net or is there any other process?
@TroyXman solution worked for us. Thanks!
The Alteryx Server didn't have Microsoft Office installed, so it didn’t have the system files/drivers necessary to perform the actions my workflow was requesting. My coworker installed the Microsoft Access 2010 Runtime and problem solved!
Thanks again for pointing us in the right direction!
I have the same problem as "Ferrari " but with an MS excel file, I have a workflow that uses the file path as the output so it can pick certain text - but when i upload to the alteryx server it gives an error saying " [Workflow.yxmd] Tool 36 - Error opening connect string: Can't create Data source Object - Class not registered, how can i fix that ?
