I am using MSDE as the database of my program.

At the begin of my program, it must display a form for user to enter the
password

After the user enters the password, I will check the password, if it is the
correct password of a user of MSDE

..

In order to check the password; I must get the password of a user of MSDE in
the first.



How can I get the password of a user of MSDE? Like that I have a sa2 in MSDE
, how can I get the password of sa2?

"ad" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> In order to check the password; I must get the password of a user of MSDE
> in
> the first.

Why don't you try to connect with username and password that user provided
and let MSDE to check if they are correct? Then you won't need to know user
passwords.

RGDS PSG

From a security perspective that's a very bad approach. You should attempt
to log in with those credentials passed and than let MSDE check the
Password. If the password is an error an exception will be thrown.

Amy.

"ad" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I am using MSDE as the database of my program.
>
> At the begin of my program, it must display a form for user to enter the
> password
>
> After the user enters the password, I will check the password, if it is
the
> correct password of a user of MSDE
>
> .
>
> In order to check the password; I must get the password of a user of MSDE
in
> the first.
>
>
>
> How can I get the password of a user of MSDE? Like that I have a sa2 in
MSDE
> , how can I get the password of sa2?
>
>
>

But there are many situations when we fail to login MSDE, like the MSDE is
stop or the net is disconnected

How can I confirm the failure is caused by incorrect password?





"Amy L." <(E-Mail Removed)> ¼¶¼g©ó¶l¥ó·s»D
:(E-Mail Removed)...
> From a security perspective that's a very bad approach. You should
attempt
> to log in with those credentials passed and than let MSDE check the
> Password. If the password is an error an exception will be thrown.
>
> Amy.
>
> "ad" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > I am using MSDE as the database of my program.
> >
> > At the begin of my program, it must display a form for user to enter the
> > password
> >
> > After the user enters the password, I will check the password, if it is
> the
> > correct password of a user of MSDE
> >
> > .
> >
> > In order to check the password; I must get the password of a user of
MSDE
> in
> > the first.
> >
> >
> >
> > How can I get the password of a user of MSDE? Like that I have a sa2 in
> MSDE
> > , how can I get the password of sa2?
> >
> >
> >
>
>

"ad" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> But there are many situations when we fail to login MSDE, like the MSDE is
> stop or the net is disconnected
>
> How can I confirm the failure is caused by incorrect password?

Just handle an exception message (message from MSDE about error type).
When MSDE is down you will probably get error no. 17 "Connection failed...
Server does not exist or access denied.", when it is up, but wrong
user/password error no. 18456 "Login failed for user ...".

RGDS PSG