Statalist


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

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


From   "Raphael Fraser" <[email protected]>
To   [email protected]
Subject   Re: st: Re: SQL Query Password/User ID
Date   Thu, 13 Dec 2007 15:51:33 -0500

Gabi,

Your instruction are very clear but while there is an option to add
user name there is none to add password.

Microsoft ODBC for Oracle Set Up:

data source name:
description:
user name:
server:

No password option. I am using XP. It is obvious that while you have
this option we don't. Can anyone explain this.

Raphael
On Dec 13, 2007 3:24 PM, Gabi Huiber <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> wrote:
> > > > > > Orvalho,
> > > > > >
> > > > > > I don't understand your comment. Would you care to elaborate?
> > > > > >
> > > > > > Raphael
> > > > > >
> > > > > > On Dec 11, 2007 1:48 PM, Orvalho Joaquim Augusto <[email protected]> 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/



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