SQL Server Compact Edition Connection Manager Editor (All Page)

  • Article

Use the SQL Server Compact Edition Connection Manager dialog box to specify properties for connecting to a SQL Server 2005 Compact Edition 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 2005 Compact Edition database before the autoshrink process runs.
  • Default Lock Escalation
    Specify the number of database locks that the SQL Server 2005 Compact Edition database acquires before it tries to escalate locks.
  • Default Lock Timeout
    Specify the default interval, in milliseconds, that a transaction will wait for a lock.
  • 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 2005 Compact Edition database.
  • Max Buffer Size
    Specify the maximum amount of memory, in kilobytes, that SQL Server 2005 Compact Edition uses before flushing data to disk.
  • Max Database Size
    Specify the maximum size, in megabytes, of the SQL Server 2005 Compact Edition database.

  • Mode
    Specify the file mode in which to open the SQL Server 2005 Compact Edition 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 2005 Compact Edition temporary database file.
  • Data Source
    Specify the name of the SQL Server 2005 Compact Edition database.
  • Password
    Enter the password for the SQL Server 2005 Compact Edition database.

See Also

Reference

SQL Server Compact Edition Connection Manager Editor (Connection Page)

Other Resources

Integration Services Error and Message Reference

Help and Information

Getting SQL Server 2005 Assistance