I'm a bit confused. First you say the QZDASOINIT job does not have TEST12 in its library list then turn around and say TEST12 showed up as part of the server job's library list.
What server job are you referring to?
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dean Eshleman
Sent: Friday, December 14, 2012 9:05 AM
Subject: Library list for iSeries Access ODBC driver
One of our users is seeing some strange behavior with their ODBC connection to the IBM I using Microsoft Access. He added a new library to the Data source definition called TEST12. Next, he went into MS Access and tried to link to some tables in the new library. After selecting the correct Data source, it displays a list of files to select from. However, no files from TEST12 are in the list. I verified that he had authority to the files. Authority is thru an authorization list. What is really strange is when I look at the library list of the QZDASOINIT job, it doesn't have TEST12 in the library list. In fact, he changed the data source and removed a library and tried it again. The library that was removed, still showed up in the library list of the server job. It seems to be holding onto a previous connection or something. We tried having him reboot his PC, but still no TEST12 in the library list.
I have tried to duplicate his problem, but have not been successful. I change the library list for my data source, and it handles it correctly. I made sure that my authority to the files was the same as his, and MS Access showed me the files just fine. Anyone have any ideas ?
Software Development Architect
1110 North Main Street
PO Box 483
Goshen, IN 46527
Phone: (574) 533-9515 x3528
This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact