Initialization Property Group - OLE DB Provider for Teradata

OLE DB Provider for Teradata User Guide

Product: OLE DB Provider for Teradata
Release Number: 15.00
Language: English (United States)
Last Update: 2018-09-28
dita:id: B035-2498
Product Category: Teradata Tools and Utilities

Initialization Property Group

Table 40: Initialization Property Group
Property	Default Value	Mode Read Write	Comments
DBPROP_AUTH_INTEGRATED	Set by user	R/W	SSO
DBPROP_AUTH_PASSWORD	Set by user	R/W	Password
DBPROP_AUTH_PERSIST_SENSITIVE_AUTHINFO	No Default	R/W
DBPROP_AUTH_USERID	Set by user	R/W	User name
DBPROP_INIT_DATABASESOURCE	Set by user	R/W	DBC Name
DBPROP_INIT_GENERALTIMEOUT	No Default	R/W	No Effect
DBPROP_INIT_HWND		R/W
DBPROP_INIT_LCID		R/W
DBPROP_INIT_MODE	No Default	R/W
DBPROP_INIT_OLEDBSERVICES	-1	R/W
DBPROP_INIT_PROMPT	DBPROMPT_COMPLETE	R/W
DBPROP_INIT_PROVIDERSTRING	Set by user	R/W	See “Setting Provider String Attributes” on page 43
DBPROP_INIT_TIMEOUT	20 seconds	R/W	Log in Time Out
TDPROP_INIT_DATAENCRYPTION	No default	R/W	When TRUE, all requests and data are transferred in encrypted format instead of in clear text. The description of the TDPROP_INIT_DATAENCRYPTION property is “Data Encryption.” The flags are: DBPROPFLAGS_DBINIT R/W To enable encryption, set the type of the property to VT_TRUE. The property is set on the ALL tab of the Data Links dialog box.
TDPROP_INIT_OUTPUTPARAMETERLOCATION	BUFFER	R/W	This property is provided only for backward compatibility. In earlier versions of OLE DB Provider for Teradata, the output parameters were incorrectly returned inside a rowset. This has been corrected in the current version and the output parameters are returned in the parameter buffer. For backward compatibility, returning output parameters via a rowset is still supported but the user has to set the value of this provider specific property to “ROWSET”.
TDPROP_INIT_SESSIONCHARACTERSET	VT_EMPTY	R/W	The Session Character Set property consists of a string contained within the TDPROPSET_TDINIT property set. It is the name of the session character set. The property type is VT_BSTR. Supported values include: “ASCII” “KANJISJIS_0S” “UTF16” “UTF8” For more information, see “Session Character Sets” on page 101.
TDPROP_INIT_USEASCOLUMNNAME	VT_EMPTY	R/W	The Use As Column Name property type is VT_BSTR. Valid string values are COLUMNNAME and COLUMNTITLE. The value of this property during initialization determines the values returned for column metadata in the following contexts: In the values referenced by the pwszName and columnid fields of the DBCOLUMNINFO structures returned by IColumnsInfo::GetColumnInfo(). In the values of the DBCOLUMN_IDNAME and DBCOLUMN_NAME columns of the columns metadata rowset (returned by IColumnsRowset::GetColumnsRowset()).
TDPROP_INIT_USEASCOLUMNNAME			This property does the following: If set to COLUMNNAME, column names are returned. If set to COLUMNTITLE, column titles are returned if these values are available. (Column names are used if column titles are unavailable.) Note: If a column alias is used in the command text, the alias gets used in these values regardless of the setting of TDPROP_INIT_USEASCOLUMNNAME. If a consumer program specifically needs either column names or column titles, explicitly set the TDPROP_INIT_USEASCOLUMNNAME property. If set to VT_EMPTY (the default), the behavior is the same as for COLUMNTITLE.