Connecting to a database after installing Exo Business

If you can't connect to a database after installing Exo Business, testing your connection with the Connection Editor can tell you what the problem is.

To test your connection

On the Exo Business login page, click the Connect to drop-down and select Setup connections....
In the Connection Editor toolbar, click Test. The EXO Business Connection Diagnostics window opens.
Select any connection from the Connection list.
Click Test.

Connection error

When testing your connection, you might get an error: "Provider cannot be found. It may not be properly installed".

You're most likely to get this error in Exo Business versions 2018.4 onwards, but it can occur in any version.

What causes the error?

The error occurs when you haven't installed the correct MSOLEDB driver for connecting Exo Business to your SQL server.

Fixing the error

To fix the error, you need to install the correct version of the MSOLEDB driver. You have two options for doing this:

Download and install the correct version from the Microsoft website.
Run the ClientInstaller (which includes the correct version).