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?