[nysimpex]

user reg form works proper but

when user tries to login

this prob comes :

dsnless connection

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Username= Password='.

db/login.asp, line 16

what is the most likely prob ? any one help me plz

[Mikeirv]

looks like you are not passign the values to your sql statement. SHould be something like "... WHERE username = 'bobby' and password = 'mypass'"

[nysimpex]

looks like you are not passign the values to your sql statement. SHould be something like "... WHERE username = 'bobby' and password = 'mypass'"

ya u r right but where is not is caps should be ?

[nysimpex]

this is the line



strSQL = "SELECT * FROM webtable where Username="& request("user")&" Password="& request("pass")