• Article

Connect to Server (Connection Properties Page) SQL Server Compact

Use this tab to view or specify options when connecting to Microsoft SQL Server Compact 3.5 SP1. or registering SQL Server Compact 3.5 SP1 in Registered Servers. Connect and Options only appear in this dialog box when connecting. Test and Save only appear in this dialog box when registering SQL Server Compact 3.5 SP1.

Options

  • Connection timeout
    Enter the number of seconds to wait for a connection to be established before timing out. The default value is 15 seconds.

  • Execution timeout
    Enter the amount of time in seconds to wait before execution of a task is completed on the server. The default value is zero seconds, which indicates there is no time-out.

  • Maximum database size
    Default size is 128 MB.

  • Default lock escalation
    Default value is 100 locks.

  • Reset All
    Replace all manually entered connection property values with the default values.

  • Connect
    Attempt a connection using the listed values.

  • Options
    Click to change the dialog and hide the additional server connection options, such as remembering the password.

  • Test
    When registering SQL Server Compact 3.5 SP1 in Registered Servers, click to test the connection.

  • Save
    Saves the settings in Registered Servers.