SQL Server Compact - Error The database file is larger than the configured maximum database size
Options
While trying to connect to a 1GB SQL Server Compact (*.sdf) database, I get the error: The database file is larger than the configured maximum database size. This setting takes effect on the first concurrent database connection only.
I have added the additional connection string parameter "Max Database Size=4096", which doesn't solve the problem.
Anyone an idea?
Comments
-
There's an option in the connection dialog to specify the maximum database size. Set that to 4091 and it should allow for the largest database that CE can support.
-
Thanks. That worked.
-
LOL - 4091! They had to set aside 5 MB for their own use.