CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> General/Other

  login with encrypted password in Microsoft Access Database

Print topic Send  topic

Author Message
shiller


Posts: 20
Posted: 01/25/2008, 6:04 AM

Dear Experts,

I'm a new to CodeCharge, I'm using CodeCharge with an Access Database and the code language is ASP 3.0.

I need help setting up Encrypt Passwords...

I click on Project> Settings > Security > Advanced .... I see the "Encrypt passwords using"... "Database function" but there is no explanation on how to set it up.

Could anyone please help....
View profile  Send private message
mrachow


Posts: 509
Posted: 01/28/2008, 1:28 AM

This feature is related to the users you are managing for your website (e.g. not the database login itself).

When storing your users passwords you have to use the same function you enter here as Code Expression.
Example:
MD5({password})

_________________
Best regards,
Michael
View profile  Send private message
shiller


Posts: 20
Posted: 01/31/2008, 5:43 AM

Hello,

Do you happen to know how to go about implementing that into my Access database, logins and passwords are stored in the table user in my Access database... CodeCharge user guide doesn't really address the issue in details...

Thanks, :-/
View profile  Send private message
shiller


Posts: 20
Posted: 02/01/2008, 7:52 AM

I've converted my passwords into MD5 format in my Access database.... and I added MD5 in the database function under security settings in CodeCharge... When I try to login, I keep getting "Login or Password is Incorrect" error message...

Has anyone successfully use MD5 function in CodeCharge?

Please help...
View profile  Send private message
shiller


Posts: 20
Posted: 02/01/2008, 1:23 PM

I finally got it to work,

1) Like Graham R Seach recommended in a previous posting on usergroup, I downloaded
the MD5 class from http://www.freevbcode.com/ShowCode.Asp?ID=741, put
clsMD5.cls into a standard module. ***don't put clsMD5.cls in a class module, because you'll receive an "undefined error message..."***

2) I use the function "DigestStrToHexStr(password_field)" to convert all passwords to MD5 format in my Access Database.

3) Project > Security > Advanced > put a check mark in "Encrypt passwords using" and put MD5({password}) in Code Expression.

4) Then create or recreate your login form and all the new settings will be implemented in it.

Hopefully somebody can benefit from this.

Shiller

View profile  Send private message
iandbige

Posts: 1
Posted: 03/08/2008, 6:48 PM

ok
_________________
IanDbigE
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.