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. |