Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Forums » Excel Forums » Data Exchange » Oracle User Name in MS Query

Oracle User Name in MS Query

Previous | Next
Latest post Tue, May 20 2008 8:56 AM by Rembo. 1 replies.

  • Fri, Apr 4 2008 10:49 AM

    Oracle User Name in MS Query

    Reply |Contact

    I am using MS Query to pull data from an Oracle source into Excel for an application that I am distributing to other users.  My Oracle username is showing up when the query is refreshed and I would like to blank this out so that other users to not have to clear it before entering their own username.  I cannot find an option anywhere to take this out, so I am wondering if the functionality exists.  Any assistance would be appreciated.

    Thank You.
    • Post Points: 21

  • Tue, May 20 2008 8:56 AM In reply to

    • Rembo
    • Top 150 Contributor
    • Joined on Tue, May 20 2008
    • Posts 3
    • Points 47

    Re: Oracle User Name in MS Query

    Reply |Contact |Mark as Answer

    Hi,


    That sort of depends on how you setup your database connection. Did you create a (User- or System)DSN? If so than my guess is that you listed a username in the DSN configuration.

    Click Start -> Run -> odbcad32.exe -> OK

    Go to the DSN configuration for your Oracle connection and blank the username. Hopefully that will solve the problem for you.

    Rembo

     
    • 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.