RE: Post to the Midrange-L mailing list

OK, assuming your profile doesn't have *ALLOBJ authority how does the QZDASOINIT job's library list compare to one of your non-ODBC job's library list? I'm asking because it sounds like you have more authority than the user. At least enough additional authority so that Access can change the OZDASOINIT job's library list.

You can try killing your QZDASOINIT job, change all running QZDASOINIT jobs to message level 4 0 *SECLVL, change the jobd QZDASOINIT starts with to be 4 0 *SECLVL also and run you test again. You might find something in the joblog.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dean Eshleman
Sent: Friday, December 14, 2012 11:01 AM
To: 'midrange-l@xxxxxxxxxxxx'
Subject: Post to the Midrange-L mailing list

First question: Is the user authorized to use library TEST12? Not the objects in the library but the library itself.

The library is secured with the same authorization list that is used to secure the files in the library. I made sure that my authority on the authorization list matched what the user had.

Second question: Where is TEST12 in your QZDASOINIT job's library list? Top, bottom or in between?

For me, it is next to last. The user portion of the library list matches what is specified in the data source.

Dean

It is located at the bottom.
On 12/14/2012 1:45 PM, Monnier, Gary wrote:

Yes. It makes sense.

First question: Is the user authorized to use library TEST12? Not the objects in the library but the library itself.

Second question: Where is TEST12 in your QZDASOINIT job's library list? Top, bottom or in between?

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dean Eshleman
Sent: Friday, December 14, 2012 10:32 AM
To: 'midrange-l@xxxxxxxxxxxx'
Subject: Re: Library list for iSeries Access ODBC driver

When the user was trying it, it didn't show up in the library list for their QZDASOINIT job. When I tried to duplicate the problem on my PC, I was able to get TEST12 to show up in the library list of my QZDASOINIT job. Does that make sense?

I found the server jobs by using WRKOBJLCK on the user profile.

Dean Eshleman
Software Development Architect

Everence Financial
1110 North Main Street
PO Box 483
Goshen, IN 46527
Phone: (574) 533-9515 x3528
www.everence.com<http://www.everence.com>

On 12/14/2012 12:17 PM, Monnier, Gary wrote:

Dean,

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?

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dean Eshleman
Sent: Friday, December 14, 2012 9:05 AM
To: 'midrange-l@xxxxxxxxxxxx'
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 ?

Dean Eshleman
Software Development Architect

Everence Financial
1110 North Main Street
PO Box 483
Goshen, IN 46527
Phone: (574) 533-9515 x3528
www.everence.com<http://www.everence.com>

________________________________________
Confidentiality Notice: This information is intended only for the individual or entity named. If you are not the intended recipient, do not use or disclose this information. If you received this e-mail in error, please delete or otherwise destroy it and contact us at (800) 348-7468 so we can take steps to avoid such transmission errors in the future. Thank you.
_______________

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.

Dean Eshleman
Software Development Architect

Everence Financial
1110 North Main Street
PO Box 483
Goshen, IN 46527
Phone: (574) 533-9515 x3528
www.everence.com<http://www.everence.com>






________________________________________
Confidentiality Notice: This information is intended only for the individual or entity named. If you are not the intended recipient, do not use or disclose this information. If you received this e-mail in error, please delete or otherwise destroy it and contact us at (800) 348-7468 so we can take steps to avoid such transmission errors in the future. Thank you.
_______________

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.