Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: Re: SQL Query Password/User ID


From   "Gabi Huiber" <ghuiber@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Re: SQL Query Password/User ID
Date   Thu, 13 Dec 2007 17:10:46 -0500

My computer does not require Windows authentication. If Tam's NT
system does, then the question is whether Stata wants his NT password
or the database password. If it's the former I can't help, but I
assume it's the latter.

Raphael: I've never used Oracle. Since your Oracle ODBC driver is not
asking you for a password when setting the data source name, there are
two possibilities: either it allows password-less access, in which
case Stata shouldn't need one; or, more likely, it won't let you burn
it into the Data Source Name for security reasons. It just wants to
make sure that every time a database connection is requested, a human
will have to type in a password.

If you're sure that Oracle will in fact allow password-less access,
and Stata is still asking you for one, and it's not your NT password,
then I can only think of one thing: you are setting the wrong dsn() in
the odbc load command. You're trying to make Stata load a table from a
database managed though some other DBMS than Oracle, such as MS
Access. Stata could tell you that the table you're looking for is not
there, but it must first ask for your password to that DBMS.

Gabi

)
> > I have version 3.85.1117. I am using an SQL server from Microsoft. For
> > some reason it doesn't save my password. Only Userid. I've set up the
> > name dialog boxe etc.. and under the "How should SQL Server verify the
> > authenticity of the login ID? -"I checked with SQL Server
> > Authentication using login ID and password entered by the user."  I
> > testd the connection, everything went well.  I am able to query the
> > data from STATA, but always a message box pops up asking me to input a
> > password [user name already supplied].
> >
> >
> >
> >
> > On Dec 13, 2007 3:24 PM, Gabi Huiber <ghuiber@gmail.com> wrote:
> > > What DBMS are you using? Do you know if you have the latest driver?
> > > The MySQL example I gave you is from a very recent project. I have the
> > > MySQL ODBC 3.51.22 driver installed. Its Add Data Source Name dialog
> > > box evidently saves my DBMS username and password like it is supposed
> > > to. I just checked.
> > >
> > > Gabi
> > >
> > >
> > >
> > >  On Dec 13, 2007 3:10 PM, Tam Phan <tamdphan@gmail.com> wrote:
> > > > I've set this connection up, however, I am still receiving the a pop
> > > > up message to insert a password (User ID was already burned in the
> > > > system) apparently  in  ODBC data source administrator, the password
> > > > is not being stored, or it wouldn't give me that option to "save
> > > > password" or anything of that nature.
> > > >
> > > > Tam
> > > >
> > > >
> > > >
> > > > On Dec 13, 2007 10:10 AM, Gabi Huiber <ghuiber@gmail.com> wrote:
> > > > > Yes, there are. Open the ODBC Data Source Administrator utility in
> > > > > Windows XP (it's under Administrative Tools in the Control Panel). The
> > > > > very first tab shows the list of user-defined DSN's. Click the Add
> > > > > button. That will take you to a new menu where you need to select a
> > > > > driver. Highlight the driver of interest and click the Finish button.
> > > > > After that, you're in business. The driver will open a form for you to
> > > > > fill in your connection pass and user id this once, and it will
> > > > > associate them forever with this data source you just set up. After
> > > > > that you just need to reference the data source in Stata, and should
> > > > > not be prompted for a password again. That's what I use in the code
> > > > > snippet I cc'd you earlier (didn't make it onto the Statalist because
> > > > > I had the gmail rich formatting turned on by mistake).
> > > > >
> > > > > Gabi
> > > > >
> > > > >
> > > > > On Dec 13, 2007 8:54 AM, Tam Phan <tamdphan@gmail.com> wrote:
> > > > > > All,
> > > > > >
> > > > > > My password and Userid for odbc SQL connectivity is different from my
> > > > > > windows user's login.  I have registered this through Window's ODBC
> > > > > > data source administrator, however, SQL server is still asking me to
> > > > > > input userid and password whenever I query the database or any part of
> > > > > > the database. I can't seem to get the password burned in.  I believe
> > > > > > the way previous emails refer to is to use windows NT authentication
> > > > > > using the network login ID.  However, are there ways to handle such
> > > > > > automation if your windows login ID is different from SQL server id
> > > > > > and password?
> > > > > >
> > > > > > Tam
> > > > > >
> > > > > >
> > > > > > On Dec 13, 2007 2:55 AM, Richard Ohrvall <richard.ohrvall@gmail.com> wrote:
> > > > > > > Dear all,
> > > > > > >
> > > > > > > I think what Ovalho meant was that when you register odbc connection,
> > > > > > > through eg. Windows' ODBC data source administrator, you can define id
> > > > > > > and password.
> > > > > > >
> > > > > > > But if you don't want to do that, you can always define the user and
> > > > > > > password directly in your Stata code, see -help odbc-. You do not need
> > > > > > > to fill in pop up windows every time you load a table.
> > > > > > >
> > > > > > > HTH
> > > > > > > Richard
> > > > > > >
> > > > > > >
> > > > > > > On 12/13/07, Raphael Fraser <raphael.fraser@gmail.com> wrote:
> > > > > > > > Orvalho,
> > > > > > > >
> > > > > > > > I don't understand your comment. Would you care to elaborate?
> > > > > > > >
> > > > > > > > Raphael
> > > > > > > >
> > > > > > > > On Dec 11, 2007 1:48 PM, Orvalho Joaquim Augusto <orvaquim@cenfoss.co.mz> wrote:
> > > > > > > > > When you register a odbc connection you can define those parameters.
> > > > > > > > >
> > > > > > > > > Then you do not have to insert that in Stata.
> > > > > > > > >
> > > > > > > > > Caveman
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > On Tue, 2007-12-11 at 13:33 -0500, Tam Phan wrote:
> > > > > > > > > > Hi all:
> > > > > > > > > >
> > > > > > > > > > Recently I've been using Stata's odbc command.  However, I found that
> > > > > > > > > > entering the password and user ids are cumbersome every single time I
> > > > > > > > > > wish to query/load tables.  Is there anyway to load/query/desc the
> > > > > > > > > > data set without SQL password/user id messsage box to pop up and
> > > > > > > > > > re-entering those information?
> > > > > > > > > >
> > > > > > > > > > Tam
> > > > > > > > > > *
> > > > > > > > > > *   For searches and help try:
> > > > > > > > > > *   http://www.stata.com/support/faqs/res/findit.html
> > > > > > > > > > *   http://www.stata.com/support/statalist/faq
> > > > > > > > > > *   http://www.ats.ucla.edu/stat/stata/
> > > > > > > > >
> > > > > > > > > *
> > > > > > > > > *   For searches and help try:
> > > > > > > > > *   http://www.stata.com/support/faqs/res/findit.html
> > > > > > > > > *   http://www.stata.com/support/statalist/faq
> > > > > > > > > *   http://www.ats.ucla.edu/stat/stata/
> > > > > > > > >
> > > > > > > > *
> > > > > > > > *   For searches and help try:
> > > > > > > > *   http://www.stata.com/support/faqs/res/findit.html
> > > > > > > > *   http://www.stata.com/support/statalist/faq
> > > > > > > > *   http://www.ats.ucla.edu/stat/stata/
> > > > > > > >
> > > > > > > *
> > > > > > > *   For searches and help try:
> > > > > > > *   http://www.stata.com/support/faqs/res/findit.html
> > > > > > > *   http://www.stata.com/support/statalist/faq
> > > > > > > *   http://www.ats.ucla.edu/stat/stata/
> > > > > > >
> > > > > > *
> > > > > > *   For searches and help try:
> > > > > > *   http://www.stata.com/support/faqs/res/findit.html
> > > > > > *   http://www.stata.com/support/statalist/faq
> > > > > > *   http://www.ats.ucla.edu/stat/stata/
> > > > > >
> > > > > *
> > > > > *   For searches and help try:
> > > > > *   http://www.stata.com/support/faqs/res/findit.html
> > > > > *   http://www.stata.com/support/statalist/faq
> > > > > *   http://www.ats.ucla.edu/stat/stata/
> > > > >
> > > > *
> > > > *   For searches and help try:
> > > > *   http://www.stata.com/support/faqs/res/findit.html
> > > > *   http://www.stata.com/support/statalist/faq
> > > > *   http://www.ats.ucla.edu/stat/stata/
> > > >
> > > *
> > > *   For searches and help try:
> > > *   http://www.stata.com/support/faqs/res/findit.html
> > > *   http://www.stata.com/support/statalist/faq
> > > *   http://www.ats.ucla.edu/stat/stata/
> > >
> >
> *
> *   For searches and help try:
> *   http://www.stata.com/support/faqs/res/findit.html
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/
>
*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



© Copyright 1996–2021 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index