All Forums Connectivity
jahotchkin 2 posts Joined 10/15
23 Oct 2015
adodb connection error - Not enough information to log on

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 1096 posts Joined 08/04
23 Oct 2015

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

jahotchkin 2 posts Joined 10/15
26 Oct 2015

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.

You must sign in to leave a comment.