Archives of the TeradataForum

Message Posted: Wed, 09 Aug 2006 @ 21:09:22 GMT

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

<-- Anonymously Posted: Wednesday, August 09, 2006 16:15 -->

Someone asked recently about the same.

How is your ODBC DSN configured? If the DSN has multiple entries under the hostname i.e., one for each node then ODBC driver select one those randomly each time it connects(helps for node balancing). If the selected one fails i.e, till the timeout then it tries the next one in the order it was listed in the DSN. So, if you have one node down or not reachable then you obviously see different connect times based how the random selection went inside ODBC driver. I would say to test consistent connection time, you use only one nodename/ip as the host name in the ODBC DSN and start connecting.

So, test all the names/ips listed in the ODBC DSN whether they are reachable and are alive. This would be your first step.

Btw, I don't think there a Teradata ODBC driver with version 3.526.1830.0

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