Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Posts
    32

    Unanswered: db2 connect errror

    UDB version 8.01.005

    db2 connect to database user userid using password
    gives me
    SQL30082N Attempt to establish connection failed with security reason "24"
    ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001

    But
    if I do
    db2 connect to database user userid
    and then enter the password it works fine

    what could be the error ?

    Urgent Help needed.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    try enclosing the db2 command in quotes:
    Code:
    db2 "connect to database user userid using password"
    May be your password contains characters that have special meaning to the shell.

  3. #3
    Join Date
    Mar 2004
    Posts
    448
    n_i is right. I have this same problem , despite using double quotes.
    The password contains the $ sign. Try to use single quote

    regards

    Mujeeb

Posting Permissions

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