Table created in AS400 DB2 library is invible to ODBC
Posted on 2013-09-11
I have a very strange problem happening with Access (2007), the ODBC iDriver for AS400 and a library in an AS400 DB.
I have various existing Access applications that link over the iDriver to tables in an AS400 DB in different libraries. 2 of these tables have even been created especially for my applications. So far, so good, no problems whatsoever, everything works fine.
I now needed yet another new table to store data on the AS400. So my colleague, who alreay created the 2 tables I am using every day, has created a new table in the same library as he created the ones that I already use (QGPL).
Well, when I try to link that new table, regardless of how I do it, that table is NOT in the table list of that library !
And I can use the original DSN, or delete the existing one and create a new one, or create a file DSN instead of a user DSN, or even create a new Access DB and try to link, log off and log in again... NO way, the (new) table remains invisible !!!
My colleague looked at everything, giving the same "attributes" to the new table as the ones of the tables I use. Didn't change anything. He even created yet another table, totally public. I can't see that one either !
Another strange thing is that I can use a connection string to establish a connection directly to that table, I can connect, I cann issue SQL statements (DELETE, INSERT), I don't get ANY errors, but nothing happens, i.e. I cannot store data in that table !
Any idea what this could be due to ?
Thanks for help