Archives of the TeradataForum

Message Posted: Mon, 31 Jan 2005 @ 19:03:08 GMT

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

Just a guess but V2R5.1 was where they added new logon options I think. (Encryption?)

Maybe there is some kind of negotiation going on in the new driver that the old one does not do since it doesnt know about it.

The environment variable you are thinking of is probably the one that avoids the wait for a DNS lookup failure.

DNS lookups are fast ... but failures are slow.

If you have 3 PEs attached to your 'abc' host network ODBC will look for hosts 'abccop1', 'abccop2', 'abccop3', 'abccop4'.

The first 3 will be fast but the last one will take a long time (10 seconds maybe)

If you create an environment variable called 'abc' and set its value to 3 then ODBC will only look for the first 3.

(This was originally designed for CLI so I am only guessing that ODBC would also use it.)

Mike Dempsey
Teradata Client Tools

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