For Database connectivity with Excel files (.xls, .xlsm, .xlsb and .xlsx), you may need to install Microsoft Access Database Engine 2016 Redistributable (accessdatabaseengine_X64.exe) if Microsoft Office is not installed on the machine.

It can be found on the Microsoft site https://www.microsoft.com/en-us/download/details.aspx?id=54920.

In case of insufficient system set up, the following error may occur [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.

This happens when there is no ODBC Data Source set in the system (for instance the Microsoft Office is not installed) or if the data source exists but its name is specified wrong in a connection string.

To check the ODBC data sources, you should run the 64-bit version of ODBC Data Sources Administrator application (it is crucial to use the 64-bit version and not the 32-bit, because Viz Trio 4.x is 64-bit application).

On the image above you can see there is no existing data source that uses Microsoft Excel Driver. To set up a new one click Add button.

In the wizard, select the Microsoft Excel Driver option and click Finish.

In the following dialog box, you should set the new data source name. The data source name (DSN) is the text that is mentioned in the connection string in Viz Trio, which is crucial to be the same as in Viz Trio.

By default, Viz Trio uses the Excel Files text as a data source name (this name is also the default name that Microsoft Office may automatically create during installation).

If you want the name to be different, you must adjust this name in Viz Trio in the connection strings, for all your database connections that use Excel files:

After setting a name, click OK to apply. Make sure the data source name appears in the list:

After you established the data source, go back to Viz Trio and test the connection again:

If you use the data source with the name that is not the default, you must edit the DSN parameter value in the connection string text box.