[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-odbc
Subject:    RE: myODBC user/pwd confusion
From:       ". . . s k i n" <skin () mindcopy ! com>
Date:       2001-01-31 16:13:19
[Download RAW message or body]

hmmm...that's too obvious... ;-)

yea, i didn't think of that, probably way too confused when i wrote the
mail...

tnx for slapping me awake!

. . . s k i n
mindcopy - http://www.mindcopy.com/

> -----Original Message-----
> From: Guillaume [mailto:webmaster@dwam.com]
> Sent: Wednesday, January 31, 2001 4:25 PM
> To: myodbc@lists.mysql.com
> Subject: Re: myODBC user/pwd confusion
>
>
> Hi
>
> what you can do is have a DEFAULT setting in MyODBC that is used
> if no other user/pw is given in your ASP...
>
> You shouldn't be surprised though... This behaviour is logical...
> Where's the point in allowing users to identify if their identity
> is overruled by the driver ?
>
> /////  D W A M   W 3   S P A C E  /////////////////////
> Guillaume de Lafontaine - webmaster@w3space.com
> . Services Internet : http://www.w3space.com
> . Annuaire Aquitaine : http://www.aquitanet.com
> . Espace TeleTravail : http://www.w3workers.com
> . DWAM.NT Docs & Resources : http://www.dwam.net
>
> -----Message d'origine-----
> De : . . . s k i n <skin@mindcopy.com>
> À : myodbc@lists.mysql.com <myodbc@lists.mysql.com>
> Date : mercredi 31 janvier 2001 15:46
> Objet : myODBC user/pwd confusion
>
>
> |Hi,
> |
> |just a little confusement involving user/pwd on my behalf.
> |
> |
> |I have a W2k server, IIS5 & mySQL. I created a new database, setup a
> |user/password combination for that and tested it. Everything ok
> (from mysql
> |shell).
> |
> |I've installed myODBC & setup a DSN for this database.
> |
> |Finally i've made an .ASP to connect to that database over myODBC.
> |
> |And here is where my confussion started; i got a connection
> refused error.
> |Trying to figure out what was wrong i ran into some (for me) very wierd
> |things: It seems it doens't matter which username/password
> combination i use
> |in the myODBC settings; even incorrect user/pwd combinations
> don't crash the
> |.ASP
> |However, when i leave out the user/pwd in the connectionstring,
> i cannot get
> |into the database anymore, unless the username/password are
> correctly filled
> |out in myODBC DSN.
> |
> |The only thing i have filled out now in the DSN entry is: DSN Name, mySQL
> |host & mySQL database (thus no user/pwd). And the connection string  does
> |contain the username/pwd.
> |
> |So i sort of conclude that username/password in the connectionstring
> |overrules what's in the myODBC DSN. And that confusses me a bit; i would
> |expect the entry in the DSN to overrule any settings in the
> |connectionstring.
> |
> |
> |Everything is running smoothly, i'm just wondering about his. Anyone got
> |some insight?
> |
> |
> |tnx
> |
> |. . . s k i n
> |mindcopy - http://www.mindcopy.com/
> |
> |
> |
> |
> |---------------------------------------------------------------------
> |Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> |posting. To request this thread, e-mail myodbc-thread2740@lists.mysql.com
> |
> |To unsubscribe, send a message to the address shown in the
> |List-Unsubscribe header of this message. If you cannot see it,
> |e-mail myodbc-unsubscribe@lists.mysql.com instead.
>
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail myodbc-thread2741@lists.mysql.com
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail myodbc-unsubscribe@lists.mysql.com instead.


---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail myodbc-thread2742@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail myodbc-unsubscribe@lists.mysql.com instead.

[prev in list] [next in list] [prev in thread] [next in thread]