The underlying provider failed to open. unable to open database file - Error on Startup

Owned by Roman Villandry
Last updated: Jun 30, 2022 by Brandon Johnson (Unlicensed)
3 min read

Applies to: CardExchange Producer v10, TrustIDv4

This error can appear when a certain database file in the Data folder directory of the application is not read properly. This can be because of the location of the Database file changing, the installation path was changed, or the current user does not have permissions to read the Data folder directory.

The easiest method to get this resolved is to open a Config tool available in your Program Files and relink the database file in your Data folder to your application.

  1. Navigate to the application Program Files x86 folder

    • For Producer v10 - C:\Program Files (x86)\CardExchange Solutions\CardExchange Gateway

    • TrustID Path - C:\Program Files (x86)\Magicard\TrustID

  2. Find these two files:

    • “CardExchange.Config.exe” and “CardExchange.Gateway.exe.config”

    • “TrustID.Config.exe” and “TrustID.exe.config”

  3. You will need to drag the .config file on to Config.exe to open it. See image below

Click Yes to open

The configuration tool will now open with a couple columns for you to select. On the right side, select Connection Strings / Application.MySettings.Database

Set the provider to SQLite.

For the Database file row, we want to point this to the cegateway.sqlite file (or trustid.sqlite file) that is found in your Data folder. If the application was installed in the default locations, you can find the file in this path here:

  • CardExchange Producer v10 - C:\Users\Public\Documents\CardExchange\Data\

  • TrustID v4 - C:\Users\Public\Documents\TrustID\Data

Select Browse next to the Database file row.

Select the SQLite file and click Open.

You will return to the Configuration Tool window. Select Save in the top left corner, and close the configuration tool. It will ask you one more time if you would like to save, select Yes.

Relaunch your application and see what the results are. If you receive the error again, read it carefully again and double-check the path set in the configuration tool. Copy the path directly from another file browser window where the database provider file is to ensure this.

 

Sometimes you may have an instance where the Administrator account you are using does not have access to the network location you are moving the cegateway.sqlite file too. In this case you can use the Advanced mode to define a path by typing it.

If you will be using a UNC Path or IP Address to connect to a network location, then you will also need to provide the escape characters to make it work. For instance, if your path is \\ServerName\CardExchange\Data\cegateway.sqlite, then you need to use \\ in front of the path like so: \\\\ServerName\CardExchange\Data\cegateway.sqlite.

 

Are you still having issues?

If this error is still occurring, reinstalling the software will be the next thing to do. Uninstall the application, and rename or remove the currently existing Data folder.

When you reinstall the application, ensure that all installation paths are set to the default paths:

  • Program Files: “C:\Program Files (x86)\CardExchange Solutions\CardExchange Gateway”

  • Data Folder: “C:\Users\Public\Documents\CardExchange\Data\”

If problems are still occurring after reinstallation, there may be a larger issue at hand. In this case, send a ticket to our Support team - Support@cardexchangeid.com