Create Iseries ODBC connection to strange formatted library name.
Posted on 2014-04-23
Hi. I am trying to create a new DSN over an ISERIES library called G.USRLIB and link an object in that library to an access database. I can create the DSN ok and see the library objects listed when I try to import into Access but when I select the file object, the link fails with the error "The Microsoft Access Database engine could not find the object 'G.USRLIB.FILENAME'. Make sure the object exists and that you spell its name and the path correctly. If G.USRLIB.FILENAME' is not a local object, check your network connection or contact the server administrator.
I believe this has to do with the "G." precursor but I'm wondering if there is some way to pull this data in directly from that library/file. I'd rather not put some update system in place to copy data to a more readable naming convention but that is a last ditch option..