Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Forums » Excel Forums » Data Exchange » Username saved somewhere in ODBC connection to i-series

Username saved somewhere in ODBC connection to i-series

Previous | Next
Latest post Tue, Sep 16 2008 5:00 PM by Nick Hodge. 1 replies.

  • Tue, Sep 16 2008 6:37 AM

    • DenisR
    • Top 500 Contributor
    • Joined on Tue, Sep 16 2008
    • Posts 1
    • Points 21

    Username saved somewhere in ODBC connection to i-series

    Reply |Contact

    Hi

    We have several shared spreadsheets used to make queries on an i-Series (using Excel 2003).

    It worked fine for a while but one day the spreadsheets started to save a user name in the connection. That means that other users need always to change the user name when updating the query.

    The ODBC connection on all clients are created as "System DSN" now but I won't tell that they have never been "User DSN".

    I have searched for a while now whithout finding where this user name is stored. So I am posting here hoping that somene can help me.

    Regards,

    Denis
    • Post Points: 21

  • Tue, Sep 16 2008 5:00 PM In reply to

    • Nick Hodge
    • Top 10 Contributor
    • Joined on Sun, Dec 23 2007
    • Southampton
    • Posts 336
    • Points 5,771
    • MVP

    Re: Username saved somewhere in ODBC connection to i-series

    Reply |Contact |Mark as Answer

    Denis

    I suspect you would do better looking to IBM as I suspect it is the iSeries ODBC driver that is storing it. I use that driver all the time and gave up with password and connection issues. I suspect it is in the setup of the connection on user machines.

    Regards
    Nick Hodge
    Microsoft MVP, Excel
    Southampton, UK
    • Post Points: 5
Page 1 of 1 (2 items) | RSS
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.