Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2006
    Posts
    5

    Unanswered: DB2 Connection Problem from Shortcut ( Error Message )

    Hi everybody

    First off all , i would like to apologize that i 've opened tihs thread but ,
    i could not found any matches in forums about my problem .

    i have a database on windows server 2000 ( db2 version 7.1 )
    and a system works on it .

    in clients , i can connect to the database with user name and password
    the Server is up , the DB is up

    but when i want to start the program from shortcut i received an error message

    User consideration
    the database not available Error [IBM][CLI Driver]SQL1403N The Username and or password supplied is incorrect .

    What can it be the reason of my problem ? The last day before , is the virus program updated in server ? can it be the reason ?
    i would thank a lot for your help in advance

  2. #2
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,
    can you post the batch file (shortcut) you are executing? What is your operating system and version, what is your db2 version and fixpack level?

    Assuming you are using Windows:
    1. create file run.bat and store into this file following text:
    db2cmd /i /c file.bat

    2. create file.bat and store into this file all db2 commands:
    db2 connect to database user username using password
    db2 select * from ... what ever command you wish to execute
    db2 connect reset

    3. create shortcut to run.bat and execute shortcut.

    Hope this helps,
    Grofaty

  3. #3
    Join Date
    Nov 2006
    Posts
    5
    Hi again Mr.Grofaty

    The problem is solved .

    The Reason was , the change of the password of a local user during virus update on a server . ( without info )

    After that we were having the following message
    SQL-ERROR-MSG:
    DSNT408I SQLCODE = -30082, ERROR: CONNECTION FAILED FOR SECURITY REASON 2 (PASSWORD INVALID)
    DSNT418I SQLSTATE = 08001 SQLSTATE RETURN CODE
    DSNT415I SQLERRP = DSNLTSC1 SQL PROCEDURE DETECTING ERROR
    DSNT416I SQLERRD = 9 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
    DSNT416I SQLERRD = X'00000009' X'00000000' X'00000000' X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC
    INFORMATION

    The password is adjusted again and the programm version is updated and it works again

    Thanks a lot again for the clue

Posting Permissions

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