Connection String Options

Alternate Security Credentials	Uses the URL to set an alternate security credentials value for client authorization when using TDV with a client restricted license.
Case Sensitive	Specifies case sensitivity in the request values.
Catalog	The name of the catalog to use.
Commit Failure	Specifies the behavior if a commit fails.
Commit Interrupt	Specifies the behavior if a commit is interrupted.
Compensate	The correcting behavior.
Connection Life Time	The maximum lifetime of a connection in seconds. Once the time has elapsed, the connection object is disposed.
Connect Timeout	The time-out for initial connection, in seconds.
Data Source	The name of the TDV data source.
Default Catalog	The default catalog for a specified connection.
Default Schema	The default schema for a specified connection.
Domain	The TDV domain to which the DataSource belongs.
Enable Fast Exec	Specifies whether to enable fast execution of queries.
Enable Flood	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.
Enable Reconnect On Error	Specifies cluster reconnection behavior.
Encrypt	Specifies whether to encrypt the connection using SSL.
Fetch Bytes	The maximum number of rows to fetch for a batch based on batch size, in bytes.
Fetch Rows	Maximum number of rows to fetch for a batch.
Host	The name of the server running TDV Server.
Ignore Trailing Spaces	Specifies whether to ignore trailing spaces at the end of values.
Kerberos KDC	The Kerberos Key Distribution Center (KDC) service used to authenticate the user.
Kerberos Realm	The Kerberos Realm used to authenticate the user with.
Kerberos SPN	The Service Principal Name for the Kerberos Domain Controller.
Locale	Value that defines the user's language and country.
Location	A path to the directory that contains the schema files defining tables, views, and stored procedures.
Logfile	A path to the log file.
Max Log File Count	A string specifying the maximum file count of log files. When the limit is hit, a new log is created in the same folder with the date and time appended to the end and the oldest log file will be deleted.
Max Log File Size	A string specifying the maximum size in bytes for a log file (for example, 10 MB). When the limit is hit, a new log is created in the same folder with the date and time appended to the end.
Max Rows	Limits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.
No Metadata	Blocks return of result-set metadata during query execution.
Optimization Prepare	Specifies whether to optimize prepare requests sent to TDV.
Other	These hidden properties are used only in specific use cases.
Param Mode	Controls the behavior of OUT parameters for stored procedures.
Password	The user's password.
Pool Idle Timeout	The allowed idle time for a connection before it is closed.
Pool Max Size	The maximum connections in the pool.
Pool Min Size	The minimum number of connections in the pool.
Pool Wait Time	The max seconds to wait for an available connection.
Port	The port of the TDV server.
Query Passthrough	This option passes the query to the TDV server as is.
Readonly	You can use this property to enforce read-only access to TDV from the provider.
Register Output Cursors	Specifies how to handle output cursors.
Request Timeout	The time-out for query commands and other requests, in seconds.
Session Timeout	Session inactivity time-out, in seconds.
Session Token	Uses the URL to set a session token value for client authorization when using TDV with a client restricted license.
SSL Client Cert	The TLS/SSL client certificate store for SSL Client Authentication (2-way SSL).
SSL Client Cert Password	The password for the TLS/SSL client certificate.
SSL Client Cert Subject	The subject of the TLS/SSL client certificate.
SSL Client Cert Type	The type of key store containing the TLS/SSL client certificate.
SSL Server Cert	The certificate to be accepted from the server when connecting using TLS/SSL.
SSO	The single-sign-on (SSO) type to use to authenticate.
Strip Duplicates	Values are true or false. Default value is true. If true, the server will detect duplicate CHAR/VARCHAR columns in subsequent rows, and will not re-transmit the data across the wire.
Strip Trailing Zeros	Determines whether decimal result values are to be returned with trailing zeroes removed.
Tables	This property restricts the tables reported to a subset of the available tables. For example, Tables=TableA,TableB,TableC.
Trace Folder	The absolute directory to save the trace file.
Trace Level	The level of information to log.
Use Connection Pooling	This property enables connection pooling.
User	The username provided for authentication with TDV Server.
User Tokens	Authentication values that can be packaged for delivery.
Validate Remote Cert	Values are true or false. Default value is false. If true, the client will validate the server's cert.
Validate Remote Hostname	Values are true or false. Default value is false. If true, the client will validate the server's hostname.
Verbosity	The verbosity level that determines the amount of detail included in the log file.
Views	Restricts the views reported to a subset of the available tables. For example, Views=ViewA,ViewB,ViewC.