Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 13 Sep 2001 @ 19:50:46 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: ODBC Compatibility - CLI connect with BI/Query
From:   Dieter N�th

Hi Gary,

  If I can only enter one node address in the TDP, does this not mean that I can only connect through that one node? Using the Teradata ODBC driver, I enter multiple node addresses.  

Do you mean the TDPID of a LOGON string? You don't specify the name of a node, you use the logical name of the teradata system, e.g .LOGON myteradata/auser,apassword;

CLI tries to resolve (using the hosts file or DNS or WINS) the IP addresses of all your nodes by looking for myteradatacop1, myteradatacop2, myteradatacop3 and so on until there's no myteradatacopXX. CLI is then using a random (?) node for logon. The default value for the TDPID is dbc.

So you probably have to place some entries in your hosts file (in W2K located at winnt/system32/drivers/etc/hosts).

BTW, if you have a slow name resolution, especially for the myteradatacopXX, the you should create a environment variable indicating the maximum numbers of nodes to look for: SET myteradata = 4


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023