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/
