SDAC

TMSConnectionOptions Members

TMSConnectionOptions class overview.

Properties

Name Description

AllowImplicitConnect (inherited from TDAConnectionOptions)

Specifies whether to allow or not implicit connection opening.

ApplicationIntent

Used to specify the application workload type when connecting to a server.

ApplicationName

The name of a client application. The default value is the name of the executable file of your application.

AutoTranslate

Used to translate character strings sent between the client and server by converting through Unicode.

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

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

FailoverPartner

Specifies the SQL Server name to which SQL Native Client will reconnect when a failover of the principal SQL Server occurs.

ForceCreateDatabase

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

InitialFileName

Specifies the name of the main database file.

IPVersion

Use the IPVersion property to specify Internet Protocol Version. The default value is ivIPv4.

KeepDesignConnected (inherited from TDAConnectionOptions)

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

Language

Specifies the SQL Server language name.

LocalFailover (inherited from TDAConnectionOptions)

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

MultipleActiveResultSets

Enables support for the Multiple Active Result Sets (MARS) technology.

MultipleConnections

Enables and disables to create additional connections to support concurrent sessions, commands and rowset objects.

NativeClientVersion

Specifies which version of SQL Native Client will be used.

NetworkLibrary

Specifies the name of the Net-Library (DLL) used to communicate with an instance of SQL Server.

NumericType (inherited from TCustomMSConnectionOptions)

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

PacketSize

Network packet size in bytes.

PersistSecurityInfo

Used to allow the data source object to persist sensitive authentication information such as a password along with other authentication information.

Provider

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.

TrustServerCertificate

Used to enable traffic encryption without validation.

UseWideMemos (inherited from TCustomMSConnectionOptions)

Used to manage field type creation for the NTEXT data type.

WorkstationID

A string identifying the workstation.
© 1997-2019 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback