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
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 Specifies the version of the Internet Protocol. The dafault 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.
© 1997-2019 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback