0 - 3 of 3 tags for adodb

I can connect to a Teradata db instance using a DSN entry.  When I reference that same DSN entry in an adodb connection string the .Open command generates the error "Not enough information to log on"  
 

    Dim conn As New ADODB.Connection

    

    conn.ConnectionString = "DSN=TDFADS_SYS" 

    conn.Open

I'm trying to build an Excel self-service tool front end for a Teradata database, but the end users will not have any Teradata drivers installed on their machines.  Is it possible to use a generic ODBC connection, and if so, does someone know what connect string to use for an ADODB recordset?
Thanks

Hello,