Oracle-L: ODBC and password expire messages

From: Martin, Alan (Contractor) (DLIS) <Alan.S.Martin_at_dla.mil>
Date: Wed, 26 Feb 2003 13:29:26 -0800
Message-ID: <F001.0055A8B5.20030226132926@fatcity.com>

Hi listers:

In another moment you'll be able to tell I'm not ODBC literate. I can query a UNIX 9i DB using SQL*Plus from my PC using a Oracle9i client, and get ORA-28002: the password will expire within 10 days. The 8i client (to a 9i DB) does not show these messages. Neither does the 8i Oracle ODBC Test. I'd like to test a 9i ODBC connection from the PC client. I don't see an Oracle ODBC Test for the 9i client ORACLE_HOME. Is it still available? Should the ORA-28002 be passed back via ODBC? How does one check for it in VB?

Thanx,
Alan Martin
Defense Logistics Information Service
Battle Creek, MI

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Martin, Alan (Contractor) (DLIS) INET: Alan.S.Martin_at_dla.mil

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Feb 26 2003 - 15:29:26 CST