Ad:

ASP Discussion Thread
Unsolved
Views: 5460

Oct 24th, 2005

login check

Expand Post »

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

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

Similar Threads

User login Check in ASP
urgent: session timeout occurs unexpectedly(given both web.config & global.asax code) in ASP.NET
no network connection ANYWHERE in Networking
Have I been activated? in Geeks' Lounge
Help with Forums. in PHP

aarya

Reputation Points: 11

Solved Threads: 0

Junior Poster

Offline

139 posts
since Sep 2005

Permalink

Oct 24th, 2005

Re: login check

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

campkev

Reputation Points: 14

Solved Threads: 19

Posting Pro in Training

Offline

484 posts
since Jul 2005

Permalink

Oct 25th, 2005

Re: login check

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

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"

Paladine

Team Colleague

Reputation Points: 211

Solved Threads: 27

Master Poster

Offline

793 posts
since Feb 2003

Permalink

Oct 25th, 2005

Re: login check

Quote originally posted by Paladine ...

Change your connection string to this format (with your application specific details of course)
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

aarya

Reputation Points: 11

Solved Threads: 0

Junior Poster

Offline

139 posts
since Sep 2005

Permalink

Oct 25th, 2005

Re: login check

<%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

aarya

Reputation Points: 11

Solved Threads: 0

Junior Poster

Offline

139 posts
since Sep 2005

Permalink

Oct 25th, 2005

Re: login check

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.

Paladine

Team Colleague

Reputation Points: 211

Solved Threads: 27

Master Poster

Offline

793 posts
since Feb 2003

Permalink

Oct 25th, 2005

Re: login check

thank u very much

aarya

Reputation Points: 11

Solved Threads: 0

Junior Poster

Offline

139 posts
since Sep 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP Forum Timeline: Error while trying the update query

Next Thread in ASP Forum Timeline: register error

DaniWeb Message

Cancel Changes

User Name
Password