Setting the Data Source Object Required Properties Values
After the consumer creates the Data Source object, the consumer must initialize the Data Source object. To initialize the Data Source object, the consumer code assigns values to properties in the DBPROPSET_DBINIT property set. The values must provide OLE DB Provider for Teradata enough information to create a Teradata session.
The consumer must set the following required properties:
|
DBPROPSET_INIT Property |
Function |
|
DBPROP_AUTH_USERID |
Teradata User ID Although Teradata Database allows semicolons in the username, OLE DB Provider for Teradata does not. If a username contains a semicolon, the call to IDBInitialize::Initialize returns a DB_SEC_E_AUTH_FAILED error code and presents the error message: [Teradata Database]The UserId, Password, or Account is Invalid
|
|
DBPROP_AUTH_PASSWORD |
Teradata Password |
|
DBPROP_INIT_DATASOURCE |
Teradata Database name or IP address (either IPv6 or IPv4) |