community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

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

Alteryx Certified Partner

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.

@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

Alteryx Certified Partner
Alteryx Certified Partner

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

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Atom

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

 

Atom

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?

Quasar

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

Meteor

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

Meteor

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.

Meteor

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

Labels