Home → Questions →

Unable to use Microsoft SQL Server Compact 4.0 with Visual Studio 2019 image

• Edit

Johelvis Guzman

25 Jun, 2021 02:59 PM

Hello,

I seem to be having an issue with Appveyor and using Microsoft SQL Server Compact 4.0 with Visual Studio 2019 image. I've previously used the Visual Studio 2017 image and everything was fine until I switched the image to Visual Studio 2019.

I've added the appveyor.yml configuration file I been using.

Error Message:
System.Data.SqlServerCe.SqlCeException : Unable to load the native components of SQL Server Compact corresponding to the ADO.NET provider of version 8876. Install the correct version of SQL Server Compact. Refer to KB article 974247 for more details.

• appveyor.yml 1.61 KB

1. Support Staff 1 Posted by Feodor Fitsner on 25 Jun, 2021 03:30 PM

   

   Can you drop a link to a build please?

   • Edit

2. 2 Posted by Johelvis Guzman on 25 Jun, 2021 04:13 PM

   

   This is the link to the failing build:

   https://ci.appveyor.com/project/johelvisguzman/dotnettoolkit-repository/builds/39754164

   • Edit

3. Support Staff 3 Posted by Feodor Fitsner on 25 Jun, 2021 08:10 PM

   

   I've never worked with SQL Server CE. Is System.Data.SqlServerCe looking for it in GAC? How do you install SQL Server CE while deploying the app to a user?

   • Edit

4. Support Staff 4 Posted by Feodor Fitsner on 25 Jun, 2021 08:34 PM

   

   OK, looks like install SQL Server CE 4.0 does the trick:

   before_build:
     - dotnet --info
     - dotnet restore
     - ps: |
         $exePath = "$env:TEMP\SSCERuntime_x64-ENU.exe"
         (New-Object Net.WebClient).DownloadFile('https://download.microsoft.com/download/F/F/D/FFDF76E3-9E55-41DA-A750-1798B971936C/ENU/SSCERuntime_x64-ENU.exe', $exePath)
         cmd /c start /wait $exePath /i /quiet /qn /norestart
   

   • Edit

5. 5 Posted by Johelvis Guzman on 26 Jun, 2021 06:08 AM

   

   That did the trick. Thank you so much :)

   • Edit