The iSeries is managed elsewhere and they claim there is no problem because it works using DB2 connect and Operations Navigator. I had always thought these products used APPC not ODBC. Is this correct?
- DB2 connect indeed uses a different approach then ODBC
- Navigator works with JDBC (and not ODBC)
- Sometimes it is recommended to upgrade the ODBCdriver when changes occur on the iSeries. (I assume you use ODBC driver from iSeries access).
- Try to "play" with dates format (in the ODBC configuration use tab server -> advanced)
Dig Deeper on Physical connections to iSeries
Related Q&A from Shahar Mor
Use work station customize object or printer type in iSeries Access to print the output of an RPG file from the AS/400 to an HP printer. Continue Reading
What to do when an application is published in IFS from Win2k3 server, and users are unable to access the shared folder on AS/400. Continue Reading
Use the the iSeries QSYSOPR message to look for any errors in passwords when running a program on the iSeries that transfers data to a spreadsheet on... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.