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 15:24:39 -0500

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/



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