Small and simple database, lightweight installation, connecting to a database file - this will sound familiar to any developer using SQL Server Compact. The similarities are not accidental, as our goal for LocalDB was to be as easy to use as SQL Server Compact (while being as powerful and compatible with full SQL Server as SQL Express).
-->Use the SQL Server Compact Edition Connection Manager dialog box to specify properties for connecting to a SQL Server Compact database.
To learn more about the SQL Server Compact Edition connection manager, see SQL Server Compact Edition Connection Manager.
Options
AutoShrink Threshold
Specify the amount of free space, as a percentage, that is allowed in the SQL Server Compact database before the autoshrink process runs.
Default Lock Escalation
Specify the number of database locks that the SQL Server Compact database acquires before it tries to escalate locks.
Microsoft Sql Server Compact Edition Database File
Default Lock Timeout
Specify the default interval, in milliseconds, that a transaction will wait for a lock.
Microsoft Sql Server Compact Edition 3.5 Download
Flush Interval
Specify the interval, in seconds, between committed transactions to flush data to disk.
Locale Identifier
Specify the Locale ID (LCID) of the SQL Server Compact database.
Max Buffer Size
Specify the maximum amount of memory, in kilobytes, that SQL Server Compact uses before flushing data to disk.
Max Database Size
Specify the maximum size, in megabytes, of the SQL Server Compact database.
Mode
Specify the file mode in which to open the SQL Server Compact database. The default value for this property is Read Write.
The Mode option has four values, as described in the following table.
| Value | Description |
|---|---|
| Read Only | Specifies read-only access to the database. |
| Read Write | Specifies read/write permission to the database. |
| Exclusive | Specifies exclusive access to the database. |
| Shared Read | Specifies that other users can read from the database at the same time. |
Persist Security Info
Specify whether security information is returned as part of the connection string. The default value for this option is False.
Temp File Directory
Specify the location of the SQL Server Compact temporary database file.
Data Source
Specify the name of the SQL Server Compact database.
Password
Enter the password for the SQL Server Compact database.
See Also
Microsoft Sql Server Compact Edition 3.5 Sp2 X64 Download
Integration Services Error and Message Reference
SQL Server Compact Edition Connection Manager Editor (Connection Page)