Results 1 to 10 of 17

Thread: DB2 can't open table - continued

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Feb 2009
    Location
    Cayman Islands
    Posts
    3,969

    Default DB2 can't open table - continued

    Samuel and Vincent got me past the error 75

    Click image for larger version. 

Name:	sqlerr.png 
Views:	108 
Size:	5.5 KB 
ID:	14240


    But Connection tests okay in the connection manager, so presumably UID and PWD are correct. The relevant bits currently look like...

    Code:
    Object oApplication is a cMyApplication
        Object oConnection is a cConnection
            Set pbLoginOnOpen to False
            Set pbAutoConnect to True 
            Use LoginEncryption.pkg                
        End_Object
    ...
    _ConnectionId.ini (renamed to avoid production runtime)
    Code:
    [connection1]
    id=KF0
    driver=DB2_DRV
    connection=HOSTNAME=KFP-DB2;PORT=50000;DATABASE=KF1
    UID=KFDBs
    DFPWD=9Y+XfbZaj52DT14Y7nfGeg==

    I step through the AddConnection Function and see the constructed connection string is
    HOSTNAME=KFP-DB2;PORT=50000;DATABASE=KF1;UID=KFDBs;PWD=·Ñò±^¦kò ÿ]sP@¿ô²

    (Does the pwd get double-hashed or something?)


    In FunctionLoginBase we get error 12293 returned and eventually we fail with no loginconnectdialog

    customrz.int looks like
    Code:
    DRIVER_NAME DB2_DRV
    SERVER_NAME DFCONNID=KF0
    DATABASE_NAME KF1
    
    
    RECNUM_TABLE YES
    PRIMARY_INDEX 0
    GENERATE_RECORD_ID_METHOD IDENTITY_COLUMN
    TABLE_CHARACTER_FORMAT OEM
    USE_DUMMY_ZERO_DATE YES
    
    
    FIELD_NUMBER 1
    FIELD_INDEX 2
    
    
    FIELD_NUMBER 2
    FIELD_INDEX 2
    
    
    INDEX_NUMBER 0
    INDEX_NAME CUSTOMRZ000
    
    
    INDEX_NUMBER 2
    INDEX_NAME CUSTOMRZ002
    Last edited by DaveR; 19-Jan-2021 at 11:56 AM.
    I should be on a beach ...

Posting Permissions

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