Re: using ms query to get as400 data

Sounds like an authority failure somewhere. Have a look at the AF entries
types in your Audit Journal.

>From: Robin Moore <Rmoore@FMARION.EDU>
>Reply-To: midrange-l@midrange.com
>To: AS400 Midrange send message <MIDRANGE-L@midrange.com>
>Subject: using ms query to get as400 data
>Date: Tue, 09 Oct 2001 17:33:06 -0400
>
>Hi all..
>   I'm having problems with getting data from the as400 using MS.. Ok
>dont laugh..
>Just kidding.. Query using ODBC Client Access Drivers..
>.
>If I run it signed on to a user(user A) having all authority it works
>fine..
>But, If I sign on to a user(user B) that only has some authority it
>gives a ODBC error..
>User B has all authority to the lib and files in that library..
>I was hoping that someone may have seen this before or read about it..
>it seems that some library or object the user B doesnt have is causing
>the problem..
>thanks.. Robin
>
>--
>Robin M Moore
>Director of Administrative Computing Services
>Francis Marion University
>843-661-1393
>
>
>_______________________________________________
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
>To post a message email: MIDRANGE-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
>or email: MIDRANGE-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.
>


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp