Jay I created another user on My PC to try out your suggestion and all was revealed (I think). The problem appeared to lie with the MySQL ODBC driver.
I created a user DSN in the ODBC control panel for the new user. Two of the TDX ODBC configuration dialogue boxes asked for a username and a password. If these are filled in, that user becomes the default user and the driver supplies both the password and user ID if none is entered at log in time. So, I removed the login details from the driver configuration and now all seems OK. I know a user DSN is only visible to one user on one machine but I still can't see why these configuration boxes are present at all. (They are also present on the System DSN setup screen) Thanks for the help John Morrison --------------------------------------------------- In article <001001c1f836$0c64f570$8102a8c0@niigziuo4ohhdt>, Jay Blanchard wrote: > From: "Jay Blanchard" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Subject: RE: Windows 2000 MySQL login > Date: Fri, 10 May 2002 10:19:15 -0500 > > [snip] > My VB application has a log-in screen with two fields, userID and > userPassword. > When these are correctly filled in, MySQL logs me in and the application > opens. > But, I can also log in (as myself) if I leave both fields blank. And the > plot > thickens when considering the following VB code snippet. > > If this code is run 'as is' then I log in. If the commented code is > restored I > am thrown out. But the code appears not to change anything. This doesn't > make > sense. > [/snip] > > Can you go to another computer where someone else is logged in to the > network, or can you log in to the network as someone else and try this? Is > your login username/password for the network the same as MySQL? > > Jay > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
