Visual Basic Question: Login/Password Authentication

[SirDice]

Originally posted here by slarty
- Open an ADO connection to the database (instantiate an ADODB.Connection object)
- Execute a SQL query to return the user's password (making sure you escape any funny characters in the username)
- Compare the password retrieved with the entered password
- For increased security, store the passwords with one-way encryption and compare the encrypted versions

{snip}

For maximum safety, check that the username is alphanumeric and reject it otherwise.

Yes. Make damn sure the username/password is something YOU want or else you might open up some SQL injection hole.

[TSeNg]

woah woah, okay getting off of topic here guys..... :-) i got less then 24 hours left.

[Delta4ce]

if you go to try2hack.nl you can find one of these on one of there levels to try to hack, but to make it in a database, there should be a database option in the controls (where u can edit the caption, font, name, etc....) and from there u can edit the database and how to update it and all.

this i know, i have done a program similiar to this in my VB class at school, i helped design the password program, but a decompiler and a knowledge of vb can easily hack the password/user program.

[99¢]

i just wrote a small example of a some-what secure login process...
care to take a look? http://www.antionline.com/showthread...hreadid=244000

[TSeNg]

I REALLY dont care if its secure, i just need the form to look at what the user typed in the text boxes, look at the database, and then say "hey i see it here, you can go on to the next form" thats it, no encryption or stuff, plain text.. hahaha
in my program you have to register, then your data will go to a access database,( i know how to do that) then you must use your email and password to go into the next form. i want the text boxes to look at the database and say "hey your info is here, you may go hit up the rest of the project" or else give them a nast message saying NO! you may not come in!!! 20 hours left.. payce

oh 99cent how am i going to link that to a database thats my main problem.

[Juridian]

You keep putting down the time you have left....if you weren't screwing around on this message board you could have had the application done hours ago.

Are you hoping for someone to write your code for you or what?

/me thinks someone hasn't been paying attention in class and is now looking for someone to save his ass.....

[TSeNg]

man, for 1, i havent put this off. Im doing the project fine bro, I have payed attention the thing is we NEVER learned it. Im not expecting you to write it for me. im here because i need help finding the write syntax to access the database .... im in a rush because there are 4 team members, and all of a sudden i went from 1 part of the project to 3 parts. im only putting the time now because i dont have much of it, and replys are vidal, everyone has helped alot, but i just need an example to off by, i guess im being too pushy about sorry, thnx for everyones help.

[Juridian]

http://msdn.microsoft.com

http://www.google.com

http://www.15seconds.com

http://www.planetsourcecode.com

[Delta4ce]

i told you how to link the database's its easy, just go to the properties menu on your right, and scroll down to database, than make the database acess!!! set up access to do what u want and it'll be fine, dood its not that hard. I have done made one before, hacked it, than made it more secure, dood its easy!!!! ahhhh, oh ya, y don't u just get a decompiler, and go to someonelses proggy and look at what they did!! that could help you out to, but dood, its easy!!!! you could have figured it out on your own!

[Juridian]

A de-compiler? Why go through that much trouble when there are millions of lines of source code available for free on the net already that would show examples of what he needs? A simple google search would have returned everything needed in less than a minute....