Search code examples
visual-studio-2010sql-server-ce-4

SQL Server Compact 4.0 does not work in VS 2010 SP1

I've installed SQL Server compact 4.0 local database and I've added a database. However, if I try to open my database, an unknown errors occurs.

I tried to restart my VS 2010 after install the SQL Server, but it does not help and I cannot open my database.

How to resolve it?

Solution

  • I did not pay attention on a error message: "event log file full". I just cleaned eventviewer in Windows and all became okay:).

    I spied this topic:

    I just emptied the event log and tried again:

    • Windows-R ("Run")
    • eventvwr

    For each event log (in the left hand pane) right-click and select "Clear all events" (backing up the existing log if you care)