Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

Publishing Workflow With SQL Server OLEDB Connection Throws Error: Can't create Data Source Object

JLinAltX
Alteryx
Alteryx
Created

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.
 
image.png
  • Alteryx Designer, Server 
    • All
  • 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

 
No ratings