All Forums Connectivity
jchen 1 post Joined 01/06
30 Jan 2006
Teradata ODBC Trouble in MS/Access

Hi, I have installed the Teradata ODBC/SQL Assistant software thru "Ttu71_tup_utilities Nov 25 2003 BCD0-0652-0000’ - Teradata ODBC version 5.1.2600.2180. My purpose is to access our Data Warehouse data in Teradata tables by using the following: 1. SQL Assistant thru ODBC 2. MS Access thru ODBC. After install the ODBC, I do not have problem using the SQL Assistant but unfortunately have problem using the MS Access database thru Teradata ODBC. When linking tables within MS/Access, I get the following message: 'MICROSOFT OFFICE ACCESS Reserved Error -7222 There is no message for this error'. Did anyone has this problem before? We greatly appreciate if you can let us know a possible solution. Thanks.Juliet

Fred 1096 posts Joined 08/04
02 Feb 2006

Probably DR 90597 (bug in driver on TTU7.1 CD's). Fixed in ODBC and later. Get updated driver from Teradata.Com downloads area or the patch server.

candyman 4 posts Joined 02/06
10 Feb 2006

I had this too...Please NOTE special ODBC settings:Go to ODBC settings / Configure / Options / advanced and look at the bottom two check boxes. They need to be checked.

ramesh_pala 2 posts Joined 04/06
18 Apr 2006

Hi all,Even i am facing the same problem. i am not able to link teradata to access.I tried the advance options too still i have the same error.Please help....thanksramesh

BBR2 96 posts Joined 12/04
18 Apr 2006

You may want to download latest ODBC patch from Teradata Website.I think TTU8.0 Windows-i386 tdodbc. downloadable should resolve your problem.Vinay

ramesh_pala 2 posts Joined 04/06
19 Apr 2006

Hi vinay,Thankyou. I intalled the TTU8.0 Windows-i386 tdodbc. But now i am not able to conect to Teradata. Error:160: Specific Driver could not be loaded due to system error 126 (teradata).Please help.RegardsRamesh

BBR2 96 posts Joined 12/04
19 Apr 2006

Ramesh,You may want to uninstall and re-install the drivers again.New TD ODBC drivers are backward compatiable. I think this should resolve the problem that you are having.Kindly let me know if you still have this issue.Vinay

emoore 1 post Joined 06/06
06 Jun 2006

I installed and uninstalled sql assistant 7.1 and tdodbc. i am getting the same error: 160: Specific Driver could not be loaded due to system error 126 (teradata). I deleted the noc folder in program files.

alvinying 4 posts Joined 07/06
17 Jul 2006

I had the same problem. And in add/remove it shows that I already had ODBC 3.04.00. I downloaded the latest ODBC driver, un-installed the old one and install ODBC driver The problem is gone.

You must sign in to leave a comment.