|
|
|
Forum Newbie
Group: Forum Members
Last Login: 2/2/2006 9:53:00 AM
Posts: 1,
Visits: 1
|
|
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
Thanks. Jchen
|
|
|
|
|
Supreme Being
Group: PAC and SFT Members
Last Login: Yesterday @ 4:20:22 PM
Posts: 327,
Visits: 504
|
|
|
Probably DR 90597 (bug in driver on TTU7.1 CD's). Fixed in ODBC 3.3.0.8 and later. Get updated driver from Teradata.Com downloads area or the patch server.
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 3/20/2006 1:52:00 PM
Posts: 4,
Visits: 1
|
|
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.
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 4/20/2006 2:48:00 AM
Posts: 2,
Visits: 1
|
|
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....
thanks
ramesh
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 10/7/2008 6:20:30 PM
Posts: 136,
Visits: 11
|
|
You may want to download latest ODBC patch from Teradata Website.
I think TTU8.0 Windows-i386 tdodbc.03.04.00.01 downloadable should resolve your problem.
Vinay
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 4/20/2006 2:48:00 AM
Posts: 2,
Visits: 1
|
|
Hi vinay,
Thankyou. I intalled the TTU8.0 Windows-i386 tdodbc.03.04.00.01. 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.
Regards
Ramesh
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 10/7/2008 6:20:30 PM
Posts: 136,
Visits: 11
|
|
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
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 6/8/2006 5:25:00 PM
Posts: 1,
Visits: 1
|
|
|
I installed and uninstalled sql assistant 7.1 and tdodbc.03.05.00.04.exe 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.
|
|
|
|
| |