AS/400: ODBC call continues to hang

409400 pts.
Tags:
AS/400
IBM iSeries
ODBC
My Uncle is using C# .NET ODBC connection to try to retrieve data from an iSeries (AS/400) database. From what he tells me, if the files and procedures are not promoted properly on the iSeries side, ODBC should call a level check error. Unfortunately, it appears the handshake between the ODBC driver and the iSeries appears to be flawed, and the ODBC call keeps hanging.

He's tried changing the connection / command time-out values on the .NET side doesn't affect the call but it just hangs forever.

Can he force a time-out in this situation? How about terminating the ODBC call? Would that work?

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • TomLiotta

    ODBC won't trigger a "level check" condition. That applies to native I/O, not SQL. It's pretty irrelevant to SQL. That doesn't mean that some condition similar to a 'level check' isn't happening; it would just mean that the ODBC calls aren't coded correctly for the structure of the tables.

    In order to know what's going on, the instance of the connection on the database server needs to be examined. First place to look will be for any messages in the connection's joblog on the server.

    Tom

    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: