SDAC

TMSConnection.Options Property

Used to specify the behaviour of a TMSConnection object.

Class

TMSConnection

Syntax

property Options: TMSConnectionOptions;

Remarks

Set the properties of Options to specify the behaviour of a TMSConnection object.

Descriptions of all options are in the table below.

Option Name Description
AccessToken Specifies the access token used for authentication in Azure Active Directory. Supported only by the prMSOLEDB provider (Microsoft OLE DB Driver for SQL Server).
ApplicationIntent Specifies the application workload type when connecting to a server.
ApplicationName Specifies the name of a client application. The default value is the name of the executable file of your application.
AutoTranslate Enables the translation of character strings sent between the client and server by utilizing Unicode conversion.
Charset Specifies the character set applied when writing string parameter values in the national encoding format.
DefaultLockTimeout Specifies the time, in milliseconds, that a transaction will wait to acquire a lock.
Encrypt Specifies whether to encrypt data before sending it over the network.
FailoverPartner Specifies the SQL Server name to which the SQL Native Client will reconnect when a failover of the principal SQL Server occurs.
ForceCreateDatabase Forces the TMSConnection to create a new database prior to opening a connection in cases where the database doesn't exist.
InitialFileName Specifies the name of the main database file.
IPVersion Specifies the version of the Internet Protocol. The default value is ivIPv4.
Language Specifies the SQL Server language name.
MSOLEDBVersion Specifies the version of the Microsoft OLE DB Driver.
MultipleActiveResultSets Enables support for the Multiple Active Result Sets (MARS) technology.
MultipleConnections Enables and disables the creation of additional connections to support concurrent sessions, commands, and row-set objects.
NativeClientVersion Specifies which version of the SQL Native Client will be used.
NetworkLibrary Specifies the name of the Net-Library (DLL) used to communicate with an instance of the SQL Server.
PacketSize Specifies the size of the network packet (in bytes).
PersistSecurityInfo Enables the data source object to persist sensitive authentication information, such as a password, along with other authentication information.
Provider Specifies a provider from the list of supported providers.
TrustServerCertificate Enables traffic encryption without validation.
UuidWithBraces Specifies whether curly braces should be added to GUID values of the uniqueidentifier field type. This option is Boolean. The default value is True.
WorkstationID Specifies a string identifying the workstation.
© 1997-2025 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback