Teradata HS Connection
Am having some difficulty in getting a Teradata Heterogeneous Service connection working.
Already run caths.sql script, updated listener + tnsnames + initialisation file.
CREATE DATABASE LINK TD CONNECT TO "user" IDENTIFIED BY "password" USING 'TD';
And any query produces an error with the following trace details:
Heterogeneous Agent Release
9.2.0.1.0
(0) [Transparent gateway for TERA] version: 3.3.00.00.0030
(0) connect string is: defTdpName=tg4tera;SYNTAX=(ORACLE8_HOA, BASED_ON=ORACLE8,
(0) IDENTIFIER_QUOTE_CHAR="",
(0) CASE_SENSITIVE=CASE_SENSITIVE_QUOTE);BINDING=<navobj>
<binding>
<datasources>
(0) <datasource name='tg4tera' type='ODBC' connect='TD'
(0) syntaxName='ODBC_TERADATA'>
(0) <driverProperties/></datasource></datasources><environment>
<misc
(0) year2000Policy='-1' consumerApi='1' sessionBehavior='4'/><queryProcessor
(0) parserDepth='2000' noInsertParameterization='true'
(0) noThreadedReadAhead='true'/></environment></binding></navobj>
(0) ORACLE GENERIC GATEWAY Log File Started at 08-Mar-04 13:21:32
(0) [NCR][ODBC Teradata Driver][Teradata RDBMS] Invalid password. (SQL State:
(0) 28000; SQL Code: -3003)
(0) (Last message occurred 2 times)
(0)
(0) Closing log file at MON MAR 08 13:21:33 2004.
From my reading it is connecting ok, but has security validation problems.
As the ODBC setup for Teradata has options for User/Password I have tried including in both, then including only in one or the other without success ... and attempted upper and lower case password.
I am successful in logging into Teradata using the same password through other ODBC tools, so unsure what to try next.
Any suggestions are welcome.