|
Archives of the TeradataForumMessage Posted: Tue, 24 Feb 2004 @ 20:19:06 GMT
Hi William, string myConnString = "DRIVER={Teradata};DBCName=dbcname;UID=user;PWD=password;DATABASE=databa se;"; OdbcConnection myConnection = new OdbcConnection(myConnString); myConnection.ConnectionTimeout = 60; myConnection.Open(); This is only for ConnectionTimeout. .NET Definition for ConnectionTimeout: "Gets or sets the time to wait while trying to establish a connection before terminating the attempt and generating an error." One available for JDBC: QueryTimeOut The query timeout limit is the number of seconds the driver will wait for a Statement to execute. If the limit is exceeded, a SQLException is thrown. The current query timeout limit is measured in seconds and zero means unlimited. To override this behavior for a specific application, use statement.setQueryTimeout(). Error from WinCLI 802 Timeout Explanation: The request has timed out. Remedy: Increase the timeout value using Statement.setQueryTimeout() or set the QueryTimeOut value in the terajdbc.conf file on the gateway. Resubmit the job. Not sure if both ConnectionTimeout (.NET) and QueryTimeout (JDBC) are same. Thanks Regards Vijay
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||