Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2004

    Unanswered: changing expired Password over ODBC

    I want to detect the expired password and change them via showcase ODBC for DB2 database.
    I am connecting to the db2 database via ODBC through VB program.
    Any help will be greatly appreciated.

  2. #2
    Join Date
    Jul 2004


    Hi Rladda:

    I had that same problem in the past with my customers, because the changed
    periodically their passwords (wich is a good practice).

    This is not a formal solution to your question, but is a workaround that might help you.
    1) Create a new user in the customer's system i.e.: USRMYAPP.
    2) assign a password to this user with the option "never expire"
    3) Grant all the required rights to these user in the databases of
    the application.
    4) Use this new user in your ODBC strings in your apps.

    I have done it this way and never had that problem again.


  3. #3
    Join Date
    Oct 2004
    I don't have permissions to create a user in the db2 system, I can only connect to it remotely over VPN via ODBC.
    Thanks for ur reply.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts