Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 14 Aug 2006 @ 09:44:16 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Password expiry with ODBC driver / Error Running Queries using JDBC driver
From:   Jin Liew

Hi there,

I'm building a Java application which needs to connect to Teradata using a username / password entered by a user. I'm using the demo version of V2R5 and trying to get my application to work with the JDBC Type 4 driver v3 or the ODBC driver that came on the demo CD.

Using ODBC - user cannot be prompted for a new password If the user's password has expired, the user needs to be prompted to enter a new password. However, with the default ODBC settings, the JDBC connection is not completed as Teradata waits for a new password to be entered - the connection seems to hang at this point, until the application is terminated. In SQL Assistant, the user is prompted for a new password and from my understanding this is the only action which is permitted. This 'hanging' can be prevented by turning 'quiet mode' on, however, it also means that the user is not able to connect and change their password. Is there a way to retrieve this expired password state and allow the user to change their password?

Using JDBC - Teradata Versions
As an alternative to ODBC, I'm using the Type 4 JDBC driver that comes with Teradata utilities v8. However, I only have access to Teradata V2R5.0, which is not compatible with that driver (it's only compatible with V2R5.1 and later versions). Is there somewhere I can get an update to V2R5.1? I haven't been able to find anything on the NCR website.


Jin Liew
Altis Consulting


  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020