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 |
|
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: 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: 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: |
TDPROP_INIT_USEASCOLUMNNAME |
|
|
This property does the following: 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. |