VBA connecion strings for Teradata SQL assistant .NET or ODBC.
I am trying to get the results of a query from Teradata SQL assistant into a table in Access , I am using the following script and I think I am not using the correct arguments for the connection string.
Can someone point out the connection strings for .NET connection or ODBC connection with Teradata SQL Assistant.
'Access script to connect to Teradata Sub importquery() Dim strConn As String
strConn = "Driver = odbc_connection_name ; Persist Security Info = True; Data Source=view_name ; Integrated security= True;"
Dim Query As String Query = "select statement"
Dim rs As New ADODB.Recordset rs.Open Query, strConn