Crazy_About_JDE
Well Known Member
Hello! Is anyone else out there successfully connecting to iSeries V5R3 files via Microsoft Access? I am able to link to the ODBC connection and add the table, but when I double-click the entry, I get this error (screenshot attached):
Could not execute query; could not find linked table. [IBM] [iSeries Access ODBC Driver][DB2 UDB]SQL0204 - "7334" in OL7334 type *FILE not found. (#-204)
(For example, Object Librarian - B7334 which points to library OL7334. In this case I was trying to link to OL7334/F9860.)
It allows me to import the files just fine.
I have updated to the latest iSeries Access for Windows V5R3 service pack and still get the same results. I have tried Access 2000 and Access 2003 and get the same result for both.
IBM Software Support helped me capture a trace log, and it appears that Microsoft Access is incorrectly forming the SQL statement. Any ideas on how to get around this?
-Tim
Could not execute query; could not find linked table. [IBM] [iSeries Access ODBC Driver][DB2 UDB]SQL0204 - "7334" in OL7334 type *FILE not found. (#-204)
(For example, Object Librarian - B7334 which points to library OL7334. In this case I was trying to link to OL7334/F9860.)
It allows me to import the files just fine.
I have updated to the latest iSeries Access for Windows V5R3 service pack and still get the same results. I have tried Access 2000 and Access 2003 and get the same result for both.
IBM Software Support helped me capture a trace log, and it appears that Microsoft Access is incorrectly forming the SQL statement. Any ideas on how to get around this?
-Tim