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 |
|
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. |
|
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. |
|
Language |
Specifies the SQL Server language name. |
|
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. |
|
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. |
|
TrustServerCertificate |
Used to enable traffic encryption without validation. |
|
WorkstationID |
A string identifying the workstation. |
