Error: The Underlying Provider Failed to Open - Unable to Open Database File (Startup Error)

Error: The Underlying Provider Failed to Open - Unable to Open Database File (Startup Error)

This error occurs when the application is unable to open the SQLite database file during startup. The issue can arise due to a variety of reasons, such as:

• The location of the database file has changed.

• The installation path of the application was modified.

• The current user does not have sufficient permissions to access the database file.

• The database file is corrupted or unavailable.

Open

Steps to Resolve the Error

You can resolve this issue by relinking the database file using the configuration tool in your application.

Open the Configuration Tool

1. Navigate to the Application's Program Files:

   • For CardExchange Producer v10: Go to C:\Program Files (x86)\CardExchange Solutions\CardExchange Gateway.

   • For TrustID v4: Go to C:\Program Files (x86)\Magicard\TrustID.

2. Locate and Open the Configuration Files:

   • For CardExchange Producer v10, find:

     • CardExchange.Config.exe

     • CardExchange.Gateway.exe.config

   • For TrustID v4, find:

     • TrustID.Config.exe

     • TrustID.exe.config

   • Drag the .config file onto the Config.exe file to open the configuration tool.

Open

3. Configure the Database Settings:

   • In the configuration tool, locate Connection Strings / Application.MySettings.Database.

   • Set the provider to SQLite.

   • In the Database file row, point to the correct database file:

     • For CardExchange Producer v10, this is C:\Users\Public\Documents\CardExchange\Data\cegateway.sqlite.

     • For TrustID v4, this is C:\Users\Public\Documents\TrustID\Data\trustid.sqlite.

   • Click Browse, select the SQLite file, and click Open.

4. Save and Close the Tool:

   • After selecting the correct file, click Save in the top-left corner of the Configuration Tool and close it. When prompted, confirm by selecting Yes.

Verify Application Path and Relaunch

After completing the steps above, relaunch your application. If you still encounter the error, review the path set in the configuration tool. You can copy the exact path directly from a file browser window to ensure it is correct.

Advanced Mode for Network Locations

If you're using a network location for the database file and your account lacks access, you can manually define the path using Advanced mode.

For network paths, ensure that you escape special characters. For example:

• If your path is \\ServerName\CardExchange\Data\cegateway.sqlite, input it as \\\\ServerName\CardExchange\Data\cegateway.sqlite.

Reinstallation as a Last Resort

If the issue persists after relinking the database file, a reinstall may be necessary:

1. Uninstall the Application.

2. Rename or Delete the Existing Data Folder:

   • C:\Users\Public\Documents\CardExchange\Data\ (for Producer v10)

3. Reinstall the Application, ensuring the installation paths are set to the default values:

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

   • C:\Users\Public\Documents\CardExchange\Data\

Still Having Issues?

If the error continues to occur after reinstallation, there could be a larger issue at play. Contact our Support team for further assistance by sending an email to Support@cardexchangeid.com.