When I use VS2010, I got an error creating a c++ project

Question

An error occurred while creating or opening the C++ browsing database file r:/t1/t1.sdf. IntelliSense and browsing information will not be available for C++ projects. Ensure that Microsoft SQL Server Compact 3.5 is installed and that no other applications are accessing the file. If this problem persists, delete the file and reopen the solution.

In a blog, the writer said that it's caused by the RAMDISK or FlashDisk, if use the harddisk, the problem will be solved. But i don't make, someone can help me?

Answer 1

As WhiteRabbit pointed out, download the "SSCERuntime-ENU.exe" from:

For VS2010: http://www.microsoft.com/en-us/download/confirmation.aspx?id=5783

For versions after VS2010: http://www.microsoft.com/download/details.aspx?id=17876

Click download, then choose the suitable version for your device (32-bit = x86, 64-bit = x64), then download and install it.

Answer 2

No amount of installing SQL Server Compact, repairing VS, etc. fixed this for me. Finally I saw something about a Network drive or RAM disk being unsuitable.

http://social.msdn.microsoft.com/Forums/vstudio/en-US/3a15f89c-074e-413c-ac6b-f8fceb64b7b1/how-do-i-enable-intellisense-to-work-on-a-ramdisk?forum=visualstudiogeneral

I assume that the database uses low level access to the file system that is incompatible with RAM disk or network drives, etc. The following setting moved the sdf file to a location that does not interfere with whatever direct access the database demands. After a VS restart the problem vanished.

tl;dr TOOLS / Options / Text Editor / C++ / Advanced / Always use fallback location = True