Error opening connect string: Can't create Data Source Object

[oliver_sayers]

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.

[s_pichaipillai]

@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

[MarqueeCrew]

Is the access DB open in another application or is the workflow already open on another Alteryx instance?

[TroyXman · Accepted solution]

After I installed the Microsoft Access Database Engine 2010, it worked fine.

[Sanji]

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?

[ddiesel]

@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!

[Ferrari]

Good morning,

today while saving a workflow on the gallery I received the error ,you could find in attached is about tool 22 an input date, where I entered the following path referring to the dfs

"\\ v-fsfile \ Allitaly $ \ db_cambiali \ file_da_caricare \ cessione_db_cambiali_mm _ *. Accdb"

The asterisk let me to choose all the files that have the same name but that differentiate for the part replaced by the asterisk. they are identical accdb files with the same extension and with the same name as the internal table.

How can I solve this problem identified with "error opening connect string: can not create data source object", in the second attachment you can read the settings of input data

Thank you

[SamDrury]

You can download the Access database engine from here: https://www.microsoft.com/en-gb/download/details.aspx?id=13255 

Download and run the executable, there are no options that you need to select.

[SamDrury]

The link I posted no longer works - in case microsoft change the location, try and search "access 2010 engine" - it should be the top result. 

https://www.microsoft.com/en-gb/download/details.aspx?id=13255

[nish437]

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 ?