 |
 |
Archives of the TeradataForum
Message Posted: Wed, 26 Jul 2006 @ 20:34:42 GMT
| Subj: | | Re: Troubleshooting Teradata Client Connections |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Wednesday, July 26, 2006 16:32 -->
| | Is there a way to tune and/or troubleshoot the connection to teradata from a client via both odbc and oledb. Once we establish a
connection, the processing is fast, but sometimes the initial connection can take up to 30 seconds to connect. | |
May be your ODBC DSN is configured with multiple cop entries(i.e., the Teradata nodes) under HostName. If one is down, ODBC waits till the
timeout (approx 20 seconds) to try the next. So, make sure all hostnames in the ODBC DSN are correct before you check anything else.
| |
