Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Long Connection Times with newer ODBC driver?
From:   Dempsey, Mike

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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023