Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Knowledge Base

Definitive answers from Designer Desktop 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