Re: Data access for non-AS400 devs?

What might be considered a best practices approach as to how a
SQL Server or VB access to AS400 data would store a user id/profile?
Some of this might be server applications throughout the day making
requests.
The server programmers want a profile to "use" to read data (and I expect
someday to update). We do have *public excluded from all files and authority
by auth lists. I want something other than a hardcoded user id/pwd inside
some text file on a windoze machine.
jim franz
----- Original Message ----- 
From: "Bill" <brobins3d@xxxxxxxxx>
To: "Midrange List" <Midrange-L@xxxxxxxxxxxx>
Sent: Tuesday, September 13, 2005 11:19 AM
Subject: Re: Data access for non-AS400 devs?


> Goodbar, Loyd (ETS - Water Valley) wrote:
> > I'm assuming he'll need an AS/400 user ID and security to the
> > library. I'm only familiar with iSeries Navigator for a GUI view of
> > the database and running SQL.
> >
> > How have you handled this situation, what tools are required? How
> > have you handled this situation, what tools are required?
>
> MS Query transferring data to either Excel or Access.
>
> I myself also use Visual FoxPro for the involved reporting needs.
>
> Bill
> -- 
> 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.
>
>