login

[Guest]

im writing an application that requires a user to login with username and
password and the system would check it again the access database. i'm also
using oledb connection to connect to the database and i'm not getting any
rows back where i do a select statement to check the username and password.

"select * from user where username = '" & txtusername.text & "' and password
= '" & txtpassword.text & "'"

 

[Greg Low [MVP]]

Hi Herb,

To make sure your connection is working, can you read other tables?

Regards,

--
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com


PS: Can I suggest you also take a look at articles on sql injection attacks?
The code you are writing is very likely to suffer from these.

 

[Ken Tucker [MVP]]

Hi,

First off you should encrypt a password before you save it. Second
the reason you are not returning any rows is that either the password or
username is wrong.

http://msdn.microsoft.com/msdnmag/issues/03/11/protectyourdata/default.aspx

Ken
----------------------
im writing an application that requires a user to login with username and
password and the system would check it again the access database. i'm also
using oledb connection to connect to the database and i'm not getting any
rows back where i do a select statement to check the username and password.

"select * from user where username = '" & txtusername.text & "' and password
= '" & txtpassword.text & "'"