I use this conn for Teradata:
Set CON = New ADODB.Connection
Set RS = New ADODB.Recordset
Set CON = New ADODB.Connection
CON.ConnectionString = "PROVIDER=MSDASQL;" & _
"DRIVER={Teradata};" & _
"DBCName=10.200.1.120;" & _
"DefaultDatabase=DATABASE;" & _
"UID=XXXXXXX;" & _
"PWD=Nove.2015;"
CON.Open
The passowrd expire each 30 days.
possible to set, automaticlly, a new password via vb6 code and the the connection CON?
Tks
Set CON = New ADODB.Connection
Set RS = New ADODB.Recordset
Set CON = New ADODB.Connection
CON.ConnectionString = "PROVIDER=MSDASQL;" & _
"DRIVER={Teradata};" & _
"DBCName=10.200.1.120;" & _
"DefaultDatabase=DATABASE;" & _
"UID=XXXXXXX;" & _
"PWD=Nove.2015;"
CON.Open
The passowrd expire each 30 days.
possible to set, automaticlly, a new password via vb6 code and the the connection CON?
Tks