You need to look at the ODBC configuration in the windows control panel. There has to be a userid/password being sent somewhere. The ODBC config can pass the windows logon info, or the same used for navigator (aka 5250) or kerberos
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Ahmed.Hussain@xxxxxxxxxx
Sent: Thursday, December 17, 2009 4:59 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Excel File ODBC Connection User
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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.