2 Replies Latest reply on Feb 14, 2018 5:05 AM by Matthew McLaughlin

    ODBC with IBM System i Driver - Does not appear to send password

    Matthew McLaughlin

      Morning, all!  Have an interesting item here...one user (Desktop 9.2 on a Windows 10 workstation) can't connect to our IBM i using ODBC.  Configuration is identical to 4 other workstations that connect with no issues.

       

      I used the trace function in the ODBC Data Source Administer and saw the following in the log:

       

      My Tableau Repo 2f4c-ae4 EXIT  SQLDriverConnectW  with return code -1 (SQL_ERROR)

      HDBC                0x000002697760C590

      HWND                0x0000000000010010

      WCHAR *             0x00007FFC087A30D8 [      -3] "******\ 0"

      SWORD                       -3

      WCHAR *             0x00007FFC087A30D8

      SWORD                       -3

      SWORD *             0x0000000000000000

      UWORD                        0 <SQL_DRIVER_NOPROMPT>

       

       

      DIAG [28000] [IBM][System i Access ODBC Driver]Communication link failure. comm rc=8015 - CWBSY1006 - User ID is invalid, Password length = 0, Prompt Mode = Never, System IP Address = 10.10.10.3 (8015)

       

       

      My Tableau Repo 2f4c-ae4 ENTER SQLGetDiagRecW

      SQLSMALLINT                  2 <SQL_HANDLE_DBC>

      SQLHANDLE           0x000002697760C590

      SQLSMALLINT                  1

      SQLWCHAR *          0x00000269789958E8

      SQLINTEGER *        0x000000DEADFFF418

      SQLWCHAR *          0x000002697899D8D8

      SQLSMALLINT               2048

      SQLSMALLINT *       0x000000DEADFFF370

       

       

      My Tableau Repo 2f4c-ae4 EXIT  SQLGetDiagRecW  with return code 0 (SQL_SUCCESS)

      SQLSMALLINT                  2 <SQL_HANDLE_DBC>

      SQLHANDLE           0x000002697760C590

      SQLSMALLINT                  1

      SQLWCHAR *          0x00000269789958E8 [       5] "28000"

      SQLINTEGER *        0x000000DEADFFF418 (8015)

      SQLWCHAR *          0x000002697899D8D8 [     181] "[IBM][System i Access ODBC Driver]Communication link failure. comm rc=8015 - CWBSY1006 - User ID is invalid, Password length = 0, Prompt Mode = Never, System IP Address = 10.10.10.3"

      SQLSMALLINT               2048

      SQLSMALLINT *       0x000000DEADFFF370 (181)

       

      Entire trace file (SQL_Morga-10.txt) attached along with log from user's workstation (log.txt)

       

      I can't figure out why this message shows a password length of 0.  I was looking to create a custom TDC but see there is no SQL_DRIVER_NOPROMPT configuration parameters listed in any of the Tableau support pages. Please note the user can log into the IBM i using all of the other departmental tools (5250 emulator, Access Client Solutions, ODBC import for Excel, iSeries Navigator)

       

      Has anyone out there seen or heard of this??  What can I do to solve this?  

       

      Thanks in advance!