Error while modifying/querying SQL Server Compact 4.0 SDF when UWF is activated on Windows 10 device
Category: sql server ce
JegaRengaKumari on Fri, 24 May 2019 14:44:57
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,
ErikEJ on Tue, 12 Nov 2019 19:17:17
SQL Compact is out of support, the only workaround is to revert to using 3.5