AS/400: ODBC call continues to hang

352420 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following