Error while modifying/querying SQL Server Compact 4.0 SDF when UWF is activated on Windows 10 device RRS feed

  • Question

  • My C# application is built using .Net framework 4.6.1 which uses sdf database file from SQL Server compact 4.0. When it is installed in a folder that is not protected by UWF in Windows 10 device, it runs fine. But if it is installed under a folder that is UWF-protected, the application throws an error System.Data.SqlServer.Ce.SqlCeError with a message "The file resolves to a path that is too long. The maximum length is 260 characters." and the application quits.

    What could be the reason for this error? 

    The same application runs fine if the sdf is from SQL Server Compact 3.5. But, we cannot move back to SQL 3.5. Can you please help me find the reason and provide a solution.

    Thanks in advance,


    Friday, May 24, 2019 2:44 PM

All replies

  • SQL Compact is out of support, the only workaround is to revert to using 3.5

    Please mark as answer, if this was it. Visit my SQL Server Compact blog

    Tuesday, November 12, 2019 7:17 PM