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
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.