User Entry Takes Precedence - OLE DB Provider for Teradata

User Entry Takes Precedence

If the user enters a Default Database or an Account String, the user entry takes precedence over attributes already specified in the provider string DBPROP_INIT_PROVIDERSTRING. For more details on the provider string, see “Setting Provider String Attributes” on page 43.

The new user entries do not change the existing attributes in the provider string.

Example  

Assume:

DBPROP_INIT_PROVIDERSTRING is:

SessionMode=ANSI;DefaultDatabase=defaultdb1;AccountString=SYSTEM ADMINISTRATOR

And assume:

The user enters into the Teradata Connection dialog, the values:

“db1”for the Default Database field

“User1”for the Account String field

Then:

The values from the Teradata Connection dialog initialize the Teradata Data Source. The user logs on as User1 on database db1.