If a query causes the temporary database to grow beyond 256MB, the query returns the error "The database file is larger than the configured maximum database size. This setting takes effect on the first concurrent database connection only."
The Maximum Database Size parameter needs to be added for the second connection as well.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
View and moderate all "Support" comments posted by this user
Mark all as spam, and block user from posting to "Support"
CompactView cant open databases bigger then 256MB.
We had the same problem with the MediaPortal2 software and resolved it by adding the Maximum Database Size parameter.
http://blogs.msdn.com/b/sqlservercompact/archive/2007/06/13/the-story-of-max-database-size-connection-string-parameter.aspx
http://forum.team-mediaportal.com/threads/database-size-error.106282/
Last edit: Anonymous 2013-11-19
View and moderate all "Support" comments posted by this user
Mark all as spam, and block user from posting to "Support"
If a query causes the temporary database to grow beyond 256MB, the query returns the error "The database file is larger than the configured maximum database size. This setting takes effect on the first concurrent database connection only."
The Maximum Database Size parameter needs to be added for the second connection as well.
Hi,
Version 1.4.4 has been released to allow the database to grow at least to twice its current size when executing queries.
Last edit: compactview 2014-06-06