Ldap Teradata conecting string
Can any one help me how to create Ldap connecting string for Teradata.
I have Teradata 14.x client
I tried like this but its not working:
Set con=createobject("adodb.connection")
Set rs=createobject("adodb.recordset")
con.Open "Provider=Teradata;DBCName=*****.com;Database=****;Uid=myUsername;Pwd=myPassword;"
.Any help will be greatly appreciated. :)
1 answer
strConnect = "Driver={Teradata};DBCName=" & Trim(TERADATA_BOX) & ";UID=" & WINDOWS_USERID & _
";AUTHENTICATION=ldap;AUTHENTICATIONPARAMETER=" & WINDOWS_USERID & "@@" & WINDOWS_PASSWORD & ";"
Set wsF = CreateObject("ADODB.Connection")
wsF.ConnectionTimeout = 120 'attempt to login for 2 minutes (in seconds)
wsF.Open strConnect
wsF.CommandTimeout = 86400 'let queries run for up to 24 Hours(in seconds)