none
Excel VBA Teradata connection RRS feed

  • Question

  • Guys,

    I am trying to create a connection to Teradata in excel via VBA but without success.

    This is what I have tried so far:

    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.

    Any suggestions?

    Thank you in advance.

    Thursday, February 27, 2020 8:15 AM

All replies

  • Found a solution:

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

    Thursday, February 27, 2020 10:03 AM