Note that my windows NT authentication is not the same as my SQL
server authentication. I believe this is the cause of the problem.
If they were, then I am able to log into windows, and set up once, and
everything will be fine. I guess there's no way to automate this.
On Dec 13, 2007 3:45 PM, Tam Phan <[email protected]> wrote:
> 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 <[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/
