SDAC

TMSCompactConnectionOptions Members

TMSCompactConnectionOptions class overview.

Properties

Name Description

AllowImplicitConnect (inherited from TDAConnectionOptions)

Specifies whether to allow or not implicit connection opening.

AutoShrinkThreshold

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

CompactVersion

Specifies which version of SQL Server Compact will be used.

DefaultLockEscalation

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

DefaultLockTimeout

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.

FlushInterval

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

ForceCreateDatabase

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.

LocaleIdentifier

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.

MaxBufferSize

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

MaxDatabaseSize

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.

TempFileDirectory

Specifies the temp file directory.

TempFileMaxSize

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