ADO.NET Property | Description |
alternatesecuritycredentials | Specifies an alternate security property value to the identity within the current session. This is used to allow the user passing security property to the data source. Note: You may get unexpected results when multiple requests are made on the same session or when multiple identities access the same session. |
caseSensitive | Specifies case sensitivity in the request values. By default (false), requests are not case-sensitive. |
catalog | Specifies the catalog that is used for the connection. |
commitFailure | Specifies the behavior if commit failed. Possible values are: rollback or bestEffort. |
commitInterrupt | Specifies behavior if commit is interrupted.Possible values are: ignore, log, fail. |
compensate | Specifies correcting behavior. If enabled, compensation blocks will be run if the transaction rolls back. Possible values: disabled or enabled. Default value is disabled. |
connectTimeout | Time-out for initial connection, in seconds. Use 0 (zero) for infinite time-out. |
dataSource | Specifies the data source that is used for all connections. |
domain | Specifies an identification string that defines a realm of administrative autonomy, authority, or control. |
enableFastExec | Valid values are true and false. The default value is false. Results are processed and returned immediately (instead of a round trip) when a query is submitted, potentially improving performance of low latency queries. |
enableFlood | Values are true or false. Default value is true. If true, the server will constantly send data, filling the network buffer.Useful for larger result sets. |
enableReconnectOnError | Specifies cluster reconnection behavior. |
encrypt | True or False. Used for SSL security. Set to True to enable SSL security. The default is False. |
errorloggingenabled | Enable ADO.NET driver log. |
fetchBytes | Maximum number of rows to fetch for a batch based on batch size, in bytes. Setting fetchBytes to a very large number can cause an Out Of Memory error in the server. The value set for fetchBytes affects the memory used on the client and the TDV server, so the value should be set based on the heap size configured. The default value is used if this property is set to zero. |
fetchRows | Maximum number of rows to fetch for a batch. The default value is used if this property is set to zero. |
host/server | TDV Server host name. |
ignoreTrailingSpace | Ignore trailing spaces at the end of values. Default: false. |
integrated_authentication | Specified the integrate authentication method with three values: '(Disabled)', 'Kerberos', 'NTLM' |
kerberos spn | Valid on Windows platform only, not useful on UNIX platforms. Kerberos SPN value, only useful if the SSO value equals Kerberos. |
keyStoreFile | Used for SSL security. Specifies the keystore file to use for verification. The file is in the PKCS#12 format. The default keystore could be found at apps/ADO.NET/ Security/cis_ado_keystore.pfx, which includes the client certificate and private key. |
keyStorePass | Used for SSL security. Specifies the password for the KeyStoreFile. The default value is ‘changeit’. |
locale | Value that defines the user’s language and country. |
maxpoolsize | Sets the maximum number of connections that are opened in the same pool at the same time. If the maximum is reached and no usable connection is available, subsequent requests are queued until a connection is available. |
minpoolsize | Sets the minimum number of connections that is maintained even if inactive to avoid the time cost of recreating new connections for a new request. |
nometadata | Blocks return of result-set metadata during query execution. |
paramMode | Controls the behavior of OUT parameters for stored procedures: • normal—Report OUT parameters in procedure metadata as OUT parameters. • return—Report OUT parameters as return values. • omit—Omit OUT parameters from metadata. • omitCursors—Omit output cursors from metadata. |
password/pwd | Specifies the password for the user name that you specify in the Username property. These values are used for your data source connection. |
pingInterval | Maximum time to wait before sending a ping request while waiting for a result from TDV, in seconds. |
pingTimeoutWindow | The length of time the JDBC or ODBC client waits before closing a connection to the TDV server, after a ping to the TDV server has failed. The value of this parameter should be greater than or equal to the "PingInterval" parameter. If a ping sent to the TDV server fails, the ODBC or JDBC client continues to send pings to TDV to check status. If these client pings continue to fail after the TimeoutWindow has expired, the ODBC or JDBC client closes the connection to the TDV server and sends a message. While the TimeoutWindow has not expired, the ODBC or JDBC client connection stays open and continues to send pings to the TDV server waiting for a response. The default for this property is 0, which means the setting is not being used. |
pooling | When true, inactive connections are saved and reused as necessary. |
port | TDV Server listening port. |
registerOutputCursors | • true—Bind or register output cursors as output parameters. • false—Do not bind or register output cursors as output parameters; instead, use SQLMoreResults to access the cursors. |
requestTimeout | Time-out for query commands and other requests |
sessionTimeout | Session inactivity timeout, in seconds. Set to zero for infinite timeout. |
sessionToken | Uses the URL to set a session token value for client authorization when using TDV with a client restricted license. Example: &sessionToken=<VALUE> |
spn | Valid on Windows platform only, not useful on UNIX platforms. Kerberos SPN value, only useful if the SSO value equals Kerberos. |
sso | Valid on Windows platform only, not useful on UNIX platforms. Single-sign-on type: ""/(Disabled), Kerberos or NTLM. The default value is "", which forces the client application to provide user and password information to connect. |
statusinterval | Log thread and connection status with a specified time interval in seconds. |
stripDuplicates | Values are true or false. Default value is false. If true, the server will detect for duplicate CHAR/VARCHAR columns in subsequent rows, and will not re-transmit the data across the wire. This would potentially lead to data savings across the wire. |
stripTrailingZeros | Determines whether decimal result values are to be returned with trailing zeros removed. |
traceFolder | Absolute directory to save trace file, the trace file name is "CsOdbcDebug_"+<DSN Name>+".log". the default folder is C:\ or $COMPOSITE_HOME |
traceLevel | Valid values are off, fatal, error (this is the default), debug, warn, info, debug, and all. The valid values for client-side log settings are off, fatal, error (default), warn, info, debug, all, stdout. On UNIX-based platforms, the log file CsOdbcDebug.log is created in the directory specified by the environment variable COMPOSITE_HOME. |
user_tokens | Authentication values that can be packaged for delivery. |
user/uid | Specifies the user name for connections to the data source. |
validateRemoteCert | Useful on Windows platform only, it is ignored on UNIX platforms. When true, the TDV client initiates handshake validation, validating the TDV certificate and using it for password encryption. If validation fails, no connection is established. When false (default), no certificate validation is performed prior to the establishment of a connection. The TDV Server certificate is loaded from the Truststore File Location set in the Studio Configuration panel. The Keystore Key Alias is used when it is configured for use. For more information, refer to “TDV Configuration Parameters” in the TDV Administration Guide. The TDV ADO.NET driver uses the system certification store to validate the certificate. The TDV Server certificate must be added to this client trust store or validation fails. |
validateRemoteHostname | Useful on Windows platform only, it is ignored on UNIX platforms. When true, the ADO.NET driver compares the value of host in the URL with the subject CN (common name) value in the certificate received from the targeted TDV Server. If the host name validation fails, the connection is not established. When false (default), the host name validation is not performed. |
AccessToken | The authorization tokens used for OAuth2 authentication. The tokens are represented in a specific format - <header>.<payload>.<signature>. Each of the parts of the token is in a JSON format. The access token is used in place of id/password credentials, with a limited lifetime & privileges. |
AccessTokenType | The type of the AccessToken. JWT (JSON Web Token) is the default supported format. JWT token is a self-contained JSON form and ideal for federation. |