Several new DSN properties have been added and a few properties have changed in the Perl Driver.
Here is the authoritative list of properties and their values currently supported in version 15.7 SP 110.
List of consolidated attribute names and values for the dsn keyword argument.
Name |
Description |
Value |
---|---|---|
ANSINull |
Determines whether evaluation of NULL-valued operands in SQL equality (=) or inequality (!=) comparisons is ANSI-compliant. If the value is true, Adaptive Server enforces the ANSI behavior that = NULL and is NULL are not equivalent. In standard Transact-SQL, = NULL and is NULL are considered to be equivalent. This option affects <> NULL and is not NULL behavior in a similar fashion. |
Boolean value. The default is false. |
BulkLogin |
Determines whether a connection is enabled to perform a bulk-copy operation. |
Boolean value. The default is false. |
ChainXacts |
If true, Adaptive Server uses chained transaction behavior, that is, each server command is considered to be a distinct transaction. Adaptive Server implicitly executes a begin transaction before any of these statements: delete, fetch, insert, open, select, and update. You must still explicitly end or roll back the transaction. If false, an application must specify explicit begin transaction statements paired with commit or rollback statements. |
Boolean value. The default is false. |
Charset |
Specifies the charset to be used on this connection. |
String value. The default character set is now set to iso_1. |
Confidentiality |
Whether data encryption service is performed on the connection. |
Boolean value. The default is false. |
CredentialDelegation |
Determines whether the server is allowed to connect to a second server using the user’s delegated credentials. |
Boolean value. The default is false. |
DetectReplay |
Determines whether the connection’s security mechanism detects replayed transmissions. |
Boolean value. The default is false. |
DetectOutOfSequence |
Determines whether the connection’s security mechanism detects transmissions that arrive out of sequence. |
Boolean value. The default is false. |
Hostname |
The host name of the client machine. |
String value |
HostPort |
Specifies the combination of host and port of the server to connect to. |
String value. The format of the string is "hostname portnumber" or "hostname:portnumber". |
Integrity |
Determines whether the connection’s security mechanism performs data integrity checking. |
Boolean value. The default is false. |
Interfaces |
The path and name of the interfaces file. |
String value. |
Keytab |
The path and name of the file from which a connection’s security mechanism reads the security key to go with the username value. |
String value. The default is NULL, that is, the user must have established credentials before connecting. |
Locale |
Determines which language and character set to use for messages, datatype conversions, and datetime formats. |
String value. |
Language |
Determines which language set to use for messages,datatype conversions, and datetime formats. |
String value. |
LoginTimeout |
Specifies the login timeout value. |
Integer value. |
MaxConnect |
Specifies the maximum number of simultaneously open connections that a context may have. |
Integer value. Default value is 25. Negative and zero values are not allowed. |
MutualAuthentication |
Determines whether the server is required to authenticate itself to the client. |
Boolean value. The default is false. |
NetworkAuthentication |
Determines whether the connection’s security mechanism performs network-based user authentication. |
Boolean value. The default is false. |
PacketSize |
Specifies the TDS packet size. |
Integer value. |
Password |
Specifies the password used to log in to the server. |
String value. |
PasswordEncryption EncryptPassword |
Determines whether the connection uses asymmetrical password encryption. |
Boolean value. The default is false. |
SecurityMechanism |
Specifies the name of the network security mechanism that performs security services for the connection. |
String value. The default value depends on security driver configuration. |
Server Servername |
Specifies the name of the server to which you are connected. |
String value. |
ServerPrincipalName Kerberos |
Specifies the network security principal name for the server to which a connection is opened. |
String value. The default is NULL, which means that the connection assumes that the server principal name is the same as its ServerName value. |
ScriptName |
The application name used when logging in to the server. |
String value. |
SslCAFile |
The path to the file containing trusted CA certificates. |
String value. |
TDSKeepalive |
Determines whether to use the KEEPALIVE option. |
Boolean value. The default is true. |
Timeout |
Specifies the connection timeout value. |
Integer value. |
UID User Username |
Specifies the name used to log in to the server. |
String value. |