Archives of the TeradataForum
Message Posted: Tue, 10 May 2011 @ 08:46:45 GMT
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.
TD server version 12.
TD Windows ODBC is the latest version, IIRC, 22.214.171.124 Excel/Access version 2007.
Windows XP, w/ latest patches
Thanks a lot.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|