Specifying the maximum temp file size using SQLSERVER.MOBILE.OLEDB.3.0

Connection string

This Microsoft.SQLSERVER.MOBILE.OLEDB.3.0 connection string can be used for connections to SQL Server Compact.

The maximum size of the temporary database file is by default 128 MB. Override this by using the following connection string.

Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=myPath\myData.sdf;
SSCE:Temp File Max Size
=256;