Skip to content

Instantly share code, notes, and snippets.

@MadLittleMods
Last active December 23, 2022 04:48
Show Gist options
  • Save MadLittleMods/1ac026f85b6da877e4ad67385ab6b6b5 to your computer and use it in GitHub Desktop.
Save MadLittleMods/1ac026f85b6da877e4ad67385ab6b6b5 to your computer and use it in GitHub Desktop.
Fix Hallmark Card Studio failing to launch on Windows 10 - Exception: Unable to load the native components of SQL Server Compact

Problem

If you have an old version of Hallmark Card Studio and recently upgraded to Windows 10, you might be running into the following error when launching the program. The specific program I ran into this with was Hallmark Home Card Studio version 22/hcs.

A problem was encountered accessing the SQL database. Exception: Unable to load the native components of SQL Server Compact corresponding to the ADO.NET provider of version 8080. Install the correct version of SQL Server Compact. Refer to KB article 974247 for more details

Solution

This article from Microsoft explains the fix in a lot of words but it's a very simple fix.

  1. Download Microsoft SQL Server Compact 3.5 Service Pack 2 for Windows Desktop from https://www.microsoft.com/en-us/download/details.aspx?id=5783
  2. Open and run SSCERuntime-ENU.exe that you just downloaded
  3. Press Yes on the warning about installing both the 64-bit and 32-bit version
  4. Click Browse and choose your Downloads folder to extract the files to
  5. Open your downloads folder and run SSCERuntime_x86-ENU.msi first (the one with x86 in the name)
    • Just run through the setup: Next -> I accept..., Next -> Install -> Finish
  6. Next install the other one, SSCERuntime_x64-ENU.msi (the one with x64 in the name)
    • Just run through the setup: Next -> I accept..., Next -> Install -> Finish
  7. 🎉 You should be able to open Hallmark Card Studio again

Relevant links and other resources

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment