The TeradataForum depends on cookies for its operation. Please refer to our Privacy page for details. By closing this banner or continuing to browse the TeradataForum website, you agree to the use of cookies.

Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 10 May 2011 @ 08:46:45 GMT

  <Prev Next>  
Next> Last>>  

Subj:   ODBC from Access to Teradata failed
From:   Faible Mou


I m trying to establish link from Access to Teradata tables but failed -- the ODBC connection established fine, but there is no table for me to choose from within the Access table selection step.

The same ODBC connection works fine for other Teradata tools e.g., Sql assistant, and I can even copy data from Teradata tables to Excel using the same ODBC connection.

I have no idea what s wrong. Googling for answer suggests me that giving the ODBC trace might help, so here it is:

What interesting to me is that I can only acquire the ODBC trace for Access, but neither Excel nor Teradata Sql assistant. So I can t even make a comparison myself.

Any help is appreciated.

My environment:

TD server version 12.

TD Windows ODBC is the latest version, IIRC, Excel/Access version 2007.

Windows XP, w/ latest patches

Thanks a lot.


  <Prev Next>  
Next> Last>>  
  Top Home Join Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2015 - All Rights Reserved    
Last Modified: 07 Sep 2015