Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

ODBC - Unexpected Return Code 4

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

  • Guest's Avatar
    Guest replied
    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

    Leave a comment:


  • Guest's Avatar
    Guest replied
    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.

    Leave a comment:


  • Guest's Avatar
    Guest replied
    ODBC - Unexpected Return Code 4

    Thanks. I'll try the service pack.

    Leave a comment:


  • Guest's Avatar
    Guest replied
    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 :-).

    Leave a comment:


  • Guest's Avatar
    Guest replied
    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

    Leave a comment:


  • Guest's Avatar
    Guest replied
    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...

    Leave a comment:


  • Guest's Avatar
    Guest started a topic ODBC - Unexpected Return Code 4

    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.
Working...
X