Re: Excel File ODBC Connection User

[Charles Wilt <charles.wilt@xxxxxxxxx>]

You need to look at the query, it's possible that teh user ID and
profile has been set there.

Otherwise, I'd guess your Widows user ID and password match the
iSeries and that is what is being used.

I suppose Single Sign On / Enterprise Identity Mapping could be coming
into play also, but most shops don't use it.

Charles

On Thu, Dec 17, 2009 at 4:58 PM,  <Ahmed.Hussain@xxxxxxxxxx> wrote:
> I have an Excel file, which pulls data from AS/400 through ODBC
> Connection. It is working fine, but I am just wondering what is the user
> profile being used to retrieve those information, since the query does not
> ask for any user id / password.
>
> Thanks,
>
> Ahmed Hussain
> BPCS Support
> 905-595-8231
> Cell: 647-502-9096
> This e-mail (including any attachments) may contain information confidential to The Clorox Company and is intended only for the use of the intended recipient(s).  If the reader of this message is not the intended recipient(s), you are notified that you have received this message in error and that any review, dissemination, distribution or copying of this message is strictly prohibited.  If you have received this message in error, please delete this message and notify the sender immediately.
> --
> 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.