SQL Server Compact - Error The database file is larger than the configured maximum database size
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.