TMSCompactConnectionOptions Members

TMSCompactConnectionOptions class overview.


Name Description

AllowImplicitConnect (inherited from TDAConnectionOptions)

Specifies whether to allow or not implicit connection opening.


Specifies the amount of free space in the database file before automatic shrink starts.


Specifies which version of SQL Server Compact will be used.


Specifies how many locks should be performed before trying escalation from row to page or from page to table.


Specifies how much time in milliseconds a transaction will wait for a lock.

DefaultSortType (inherited from TDAConnectionOptions)

Used to determine the default type of local sorting for string fields. It is used when a sort type is not specified explicitly after the field name in the TMemDataSet.IndexFieldNames property of a dataset.

DisconnectedMode (inherited from TDAConnectionOptions)

Used to open a connection only when needed for performing a server call and closes after performing the operation.

Encrypt (inherited from TCustomMSConnectionOptions)

Specifies if data should be encrypted before sending it over the network.


Specifies the interval at which committed transactions are flushed to disk.


Used to force TMSCompactConnection to create a new database before opening a connection, if the database is not exists.

KeepDesignConnected (inherited from TDAConnectionOptions)

Used to prevent an application from establishing a connection at the time of startup.


Used to specify the preferable locale ID.

LocalFailover (inherited from TDAConnectionOptions)

If True, the TCustomDAConnection.OnConnectionLost event occurs and a failover operation can be performed after connection breaks.


Specifies how much memory SQL Server Compact Edition can use before flushing changes to disk.


Specified maximum size of the main database file.

NumericType (inherited from TCustomMSConnectionOptions)

Specifies the format of storing and representing the NUMERIC (DECIMAL) fields for all TCustomMSDataSets associated with the given connection.

Provider (inherited from TCustomMSConnectionOptions)

Used to specify a provider from the list of supported providers.

QuotedIdentifier (inherited from TCustomMSConnectionOptions)

Causes Microsoft SQL Server to follow the SQL-92 rules regarding quotation mark delimiting identifiers and literal strings.


Specifies the temp file directory.


Specified maximum size of the temporary database file.

UseWideMemos (inherited from TCustomMSConnectionOptions)

Used to manage field type creation for the NTEXT data type.
© 1997-2019 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback