DaniWeb Forum Index > Web Development > ASP

login check

Please support our ASP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Sep 2005

Posts: 139

Reputation: aarya is an unknown quantity at this point

Solved Threads: 0

aarya

Offline

Junior Poster

login check

Oct 24th, 2005

i have database in which i hava login information iwa nted to check weather the persons login information is correct or wrong.
i m very new to asp. so any body help how i have to proceed

 Help with Code Tags 
 ASP Syntax (Toggle Plain Text) 
<%dim user,pass
user=request.form("usercode")
pass=request.form("pass")
response.write(user)
response.write(pass)
' Open database
Dim Conn, RS
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Driver={MySql ODBC 3.51 Driver}; Server=localhost; database=slogin; uid=user 
 
; pwd=pass option=3;"
Set RS = Conn.Execute("SELECT * From userss where username='user' and password='pass'")
if RS="user" then 
response.write("login")
end if
%>
<%dim user,pass
user=request.form("usercode")
pass=request.form("pass")
response.write(user)
response.write(pass)
' Open database
Dim Conn, RS
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Driver={MySql ODBC 3.51 Driver}; Server=localhost; database=slogin; uid=user 

; pwd=pass option=3;"
Set RS = Conn.Execute("SELECT * From userss where username='user' and password='pass'")
if RS="user" then 
response.write("login")
end if
%>

i m trying some how like this but getting error. pls help

Last edited by Paladine; Oct 25th, 2005 at 12:28 pm. Reason: Adding Code blocks

•

Join Date: Jul 2005

Posts: 483

Reputation: campkev is an unknown quantity at this point

Solved Threads: 19

campkev

Offline

Posting Pro in Training

Re: login check

Oct 24th, 2005

what error message exactle are you getting? Also, your code is classic asp but you are posting in the asp .net forum.

•

Join Date: Feb 2003

Posts: 793

Reputation: Paladine has a spectacular aura about

Solved Threads: 27

Paladine

Offline

Master Poster

Re: login check

Oct 25th, 2005

Change your connection string to this format (with your application specific details of course)

 Help with Code Tags 
 ASP Syntax (Toggle Plain Text) 
oConn.Open "Provider=MySQLProv;" & _
           "Data Source=mySQLDB;" & _
           "User Id=myUsername;" & _
           "Password=myPassword"
oConn.Open "Provider=MySQLProv;" & _
           "Data Source=mySQLDB;" & _
           "User Id=myUsername;" & _
           "Password=myPassword"

Assistant Manager, Pharmacy Informatics
Wordpress Learning Blog
Updated : ASP.Net Login Code

•

Join Date: Sep 2005

Posts: 139

Reputation: aarya is an unknown quantity at this point

Solved Threads: 0

aarya

Offline

Junior Poster

Re: login check

Oct 25th, 2005

•

Originally Posted by Paladine

Change your connection string to this format (with your application specific details of course)
Help with Code Tags

ASP Syntax (Toggle Plain Text)
oConn.Open "Provider=MySQLProv;" & _
           "Data Source=mySQLDB;" & _
           "User Id=myUsername;" & _
           "Password=myPassword"
oConn.Open "Provider=MySQLProv;" & _ "Data Source=mySQLDB;" & _ "User Id=myUsername;" & _ "Password=myPassword"

but i dont have any problem with my database connection.
i think problem with the login information check with database

•

Join Date: Sep 2005

Posts: 139

Reputation: aarya is an unknown quantity at this point

Solved Threads: 0

aarya

Offline

Junior Poster

Re: login check

Oct 25th, 2005

<%dim user,pass
user=request.form("usercode")
pass=request.form("pass")
response.write(user)
response.write(pass)
' Open database
Dim Conn, RS
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Driver={MySql ODBC 3.51 Driver}; Server=localhost; database=slogin; uid=user; pwd=pass;

option=3;"
Set RS = Conn.Execute("SELECT * From userss where username='user' and password='pass'")
if RS.EOF then
response.write("not found")
else
response.write("u have loged in")
end if
' display results
'While Not RS.EOF
'Response.Write RS.Fields("userco") & "<br>"
'RS.MoveNext
'Wend
' closing connection
RS.Close
Conn.Close
Set RS = Nothing
Set Conn = Nothing%>

i m using thsi code if the login information is correct still it give sthe logininformation not found

•

Join Date: Feb 2003

Posts: 793

Reputation: Paladine has a spectacular aura about

Solved Threads: 27

Paladine

Offline

Master Poster

Re: login check

Oct 25th, 2005

Change this select statment as : ("SELECT * From userss where username=" + user + "and password=" + pass)

Could be another thought. Remember, always test the SELECT statement as is outside the application to see if it returns what you are actually sending in.

Assistant Manager, Pharmacy Informatics
Wordpress Learning Blog
Updated : ASP.Net Login Code