 |
 |
Archives of the TeradataForum
Message Posted: Thu, 13 Sep 2001 @ 19:50:46 GMT
| 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
Dieter
| |
