XSLB File Format is not accepting in Alteyx Server Private Studio

Question

Hello All,

I require expert advice regarding the Alteryx Server.

Recently, while publishing an Alteryx Workflow in Alteryx Server (Private Studio), I encountered an error stating that "Error opening connect string: Can't create Data Source Object', with the primary check revealing that the.xlsb file format is not supported by the Server.

How can this problem be resolved?

Alteryx Version: 2021.2.35394

MRod · Answer

You must have a Microsoft driver installed for Access 2010 on the Server machine.  You can find the driver here:

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

Once installed, the xlsb files will appear in the list of All Data Sources when adding a new input.