Error: “ [WORKFLOW.yxmd] Tool 1 - Error opening connect String: Can't create Data Source Object.”
Environment Details
When publishing a workflow with a SQL Server Native Client 11 OLEDB connection, Designer returns with the error:
[WORKFLOW.yxmd] Tool 1 - Error opening connect String: Can't create Data Source Object.
- Alteryx Designer, Server
- SQL Server Native Client 11 OLEDB
Cause
The SQL Serve Native Client 11 OLEDB driver is missing on the Alteryx Server host or from specific worker nodes for a multi-node Alteryx Server.
Resolution
The SQL Server Native Client 11 OLEDB driver needs to be installed on the Alteryx Server running the workflow. If the Alteryx Server is a multi-node setup with the worker on a different node or additional worker nodes, the OLEDB driver will need to be installed on all worker nodes.
Additional Resources