Archives of the TeradataForum

Message Posted: Tue, 16 Jul 2013 @ 17:53:11 GMT

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

When you execute a query or Import in SQL Assistant the app always sets the Command Timeout to zero.

This tells ODBC to continue waiting rather than stop after some predefined time.

When we fetch meta-data for the Database Tree however we use a function provided by the Microsoft ODBCConnection object. That function has no way to specify a timeout, so if network or locking problems cause the default timeout to be exceeded then the function will abort. (Times may also be much longer if you use the 'X' [restricted] views)

One alternative might be to use the Teradata.Net connection instead of ODBC.

Another option is to use the "Save Database Tree information ..." option together with the "Load only column names for views" sub-option. This will be much faster so it should avoid the problem. (it uses a 2 minute timeout) [The options are on the DB Tree tab] However these options only affect retrieval of Column information - not the Tables and Views.

Mike Dempsey

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