Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

ODBC - Unexpected Return Code 4

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • ODBC - Unexpected Return Code 4

    Oddly, this problem only seems to occur if I am connected to the AS/400 specified in the DSN with a profile that is different from my NT login name.

  • #2
    ODBC - Unexpected Return Code 4

    Does it happen on any particular data type? Are you up to date on CA service packs? Just some thoughts that come to mind...

    Comment


    • #3
      ODBC - Unexpected Return Code 4

      I don't think that the data type is not relevant as the error occurs before I can even connect to the AS/400 - on the ADO Connection.Open() call. I am on Client Access Express V4R4M0. This version is the one included by my company in the desktop build... I don't think I can change it as quickly as I need. I have to try to work around this quickly. I've also noticed that the login box does not pop up automatically if I am not connected to the target AS/400. (I get the same error as above in this case.) I'm sure that it used to. Thanks, Andy

      Comment


      • #4
        ODBC - Unexpected Return Code 4

        You should probably make sure you're on the latest service packs for V4R4. You can find them here. Heopfully someone else can chime in with a quick answer, if that doesn't help :-).

        Comment


        • #5
          ODBC - Unexpected Return Code 4

          Thanks. I'll try the service pack.

          Comment


          • #6
            ODBC - Unexpected Return Code 4

            Andrew, Have you tried going through and re-configuring the DSN? One other option might be to delete and recreate. Bill > Oddly, this problem only seems to occur if I am connected to the AS/400 specified in the DSN with a > profile that is different from my NT login name.

            Comment


            • #7
              ODBC - Unexpected Return Code 4

              I am trying to connect to an AS/400 using ADO though Excel, but for some AS/400 systems I receive the following error: Communication Link Failure. Comm RC=4 - CWB0999 - Unexpected error - unexpected return code 4. This is not happing for all our AS/400s, but I can't see any differences in, say, the DSN settings. Does anyone have any further information on this message? Thanks, Andy

              Comment

              Working...
              X