adodb connection error - Not enough information to log on

[jahotchkin]

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

    Debug.Print Err.Description  ' returns:  [Teradata][ODBC Teradata Driver] Not enough information to log on

I've also created a connection string that bypasses the DSN (references ODBC directly) but the error is still generated.  

    conn.ConnectionString = "DRIVER=Teradata;UID=;AUTHENTICATION=;USEINTEGRATEDSECURITY=Y;DBCNAME=tdfadscop1.gsm1900.org" ' not enough info

    conn.Open

    Debug.Print Err.Description  ' returns:  [Teradata][ODBC Teradata Driver] Not enough information to log on

The DSN entry is defined to use integrated security.  I believe adodb isn't passing this information on to the db instance which then causes the connection to fail.

Does anyone have an example of an vba adodb connection string that works with Integrated Security?

Thanks in advance.

[Fred]

Try adding "Persist Security Info=true;" to your connection string.

[jahotchkin]

Hi Fred,

Thanks for the suggestion.  Unfortunately the error remains.  I still get:

[Teradata][ODBC Teradata Driver] Not enough information to log on

Using a connection string of:

conn.ConnectionString = "DRIVER=Teradata;UID=;AUTHENTICATION=;USEINTEGRATEDSECURITY=Y;DBCNAME=tdfadscop1.gsm1900.org;Persist Security Info=true;"

I tried several different versions of the string above but the error remains unchanged.

Appreciate the suggestion.