I am also trying to connect MS Access to NCR Teradata. I have not been able to connect through ADODB connection - when I try to open the connection I get this error: "Can't find host [MyServer]Cop1

I am trying to connect MS Access to NCR Teradata.  Ultimately I want to use Access to send pass through queries to teradata and receive the results.  I have not been able to connect through ADODB connection.

Error1:  "Can't find host [MyServer]Cop1"  
Error2:  "10065 WSA E HostUnreach: The teradata server can't currently be reached over this network"

I'm trying to use a standard ADODB connection but it doesn't seem to be working...

Option Compare Database
Option Explicit
 
Public Sub RunPassThroughQuery() '(SQLString As String)
    Dim oConn As ADODB.Connection
    Dim oRec As ADODB.Recordset
    Dim conStr As String   'connection string
    Dim rConn As ADODB.Connection
    Dim strDir As String
    
    On Error GoTo ErrorHandle
    
    Set rConn = CurrentProject.Connection
    Set oConn = New ADODB.Connection
    
    Set oRec = New ADODB.Recordset
    
    With oConn
        .CursorLocation = adUseClient
        .CommandTimeout = 3600
        .Open "Driver={Teradata};DBCName=[P5450];Database=[IW_Deflt_ProdDB_V];Connect Timeout=3600;Uid= abc;Pwd= 123"
    End With
    
    'Run the SQL command on the Teradata warehouse
    'oRec.Open SQLString, oConn 'set other attributes if necessary
    
    If oRec.RecordCount < 1 Then
        MsgBox "There were no records to import.  This is probably a bug, please contact development."
        Exit Sub
    End If
    
    oRec.Close
    oConn.Close
    rConn.Close
    
    Exit Sub
    
ErrorHandle:
 
MsgBox Error()
Exit Sub
 
End Sub

Select allOpen in new window