Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2009
    Posts
    3

    Unanswered: DB2, Instances and PHP

    Hello all,

    Got 2 db2 instances DB2 and DB2_915, using on IBM z/VM 9 & 10. (DB2 CONNECT Client 8.1 on Windows )

    I have cataloged LATIN1(819) DB on DB2 ($server1) and CYRILLIC (915) DB on DB2_915 ($server2)

    I have set codepage by DB2SET CODEPAGE=xxx for each one.
    So, that works and i can connect and select in every DB.

    On php, when using

    putenv("DB2INSTANCE=DB2");
    $db = db2_connect($server1,$Logindba1,$Passdba1);
    putenv("DB2INSTANCE=DB2_915");
    $db = db2_connect($server2,$Logindba2,$Passdba2);

    The first is ok, second returns [IBM][CLI Driver] SQL3282N error.

    if I change order

    putenv("DB2INSTANCE=DB2_915");
    $db = db2_connect($server1,$Logindba1,$Passdba1);
    putenv("DB2INSTANCE=DB2");
    $db = db2_connect($server2,$Logindba2,$Passdba2);

    The first is ok, second returns [IBM][CLI Driver] SQL3282N error.

    So that works separately in PHP pages.

    But I dont understand :
    when I use db2_connect function, the following putenv() fonction seems to be inoperand.

    I can't use one instance, cause DB are in different codepages.
    I need to connect several DB in same PHP Page

    Any solution ?

    Thanks
    Fred
    Last edited by Fredodido; 06-17-09 at 06:00.

  2. #2
    Join Date
    Jun 2009
    Posts
    3
    up ! if someone got any solution

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    I would start with reading the explanation for the error message:
    SQL3282N The supplied credentials are not valid.

    Explanation:

    Either or both the distinguished name (DN) of the user and the password
    that were specified were not valid.

    This error may occur when a user is running in a Windows 2000 domain
    environment , which supports LDAP, and logs into a local account which
    may not have sufficient authority.

    User response:

    Resubmit the command using valid values for both the distinguished name
    (DN) of the user and the password.

    If you are working in a Windows 2000 domain environment, ensure that
    logon with an account that has sufficient authority.
    SQL3282N The supplied credentials are not valid.

    Explanation:

    Either or both the distinguished name (DN) of the user and the password
    that were specified were not valid.

    This error may occur when a user is running in a Windows 2000 domain
    environment , which supports LDAP, and logs into a local account which
    may not have sufficient authority.

    User response:

    Resubmit the command using valid values for both the distinguished name
    (DN) of the user and the password.

    If you are working in a Windows 2000 domain environment, ensure that
    logon with an account that has sufficient authority.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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