Excel VBA connection to Teradata

[toci1980]

Guys,

I am struggling to create connection to Teradata with VBA.
I have tried these solutions, but nothing works.

Public TerConnection As New ADODB.Connection
Sub test()

TerConnection.Open "Provider=Teradata;DBCName=server_name;Database=master;Uid=xxxxxx;Pwd=xxxxx;"


MsgBox "Connected"

End Sub

TerConnection.Open "Driver={Teradata};DBCName=server_name;Database=master;Uid=xxxxxx;Pwd=xxxxxx;"

Also I have tried both options with References in VBA:
1. Microsoft Active X Object 2.8/6.1
2. Microsoft Active X Object Recordset 2.8/6.0 library

I have Office365 64bit and ODBC drivers.

Any idea how to connect to Teradata via VBA.

Thanks.

 

[toci1980]

Found a solution:

conn.Open "Driver={Teradata Database ODBC Driver 16.20};DBCName=server_name;Database=master;CharSet=UTF8;Uid=xxxxxx;Pwd=xxxxxx;"