Statalist


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

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


From   "Tam Phan" <tamdphan@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Re: SQL Query Password/User ID
Date   Thu, 13 Dec 2007 08:54:32 -0500

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/



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