2. ASPRunnerPro General questions
  3. Problem with user log in
This topic is locked

Problem with user log in

 		12/17/2003 6:54:12 AM
ASPRunnerPro General questions
author

hi there

i have made a project which has a login page when i login as myself all is well, but when i try to login as someonelse i get

Error number -2147217913

Error description [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

Url = list.asp
the reason i dont understand is that i can see that i am logged in as said user but nothing is displayed other than the error i am using server map path and usin an access database so nothing to do with sql here?
Sergey Kornilov admin 12/17/2003

Hi,
what login method do you use (hardcoded or from database)?
Do you use any advanced security options?
Best regards,

Serget Kornilov
500079 12/17/2003

login is via database

the project lives in a sub directory from the main site and the main site has nt login security but i dont think that makes any difference as the log in procedure works its just that records are not displayed?
500080 12/17/2003

NT hosting often has a Private directory outside your domain for putting your Db's and such like in. If you've one you may need to go "../../private/mydatabase.mdb" (notice the extra ../ in there) within the dbconnection.asp file.
Hope that helps
Michael
Sergey Kornilov admin 12/18/2003

Futurefiles,
Could you please zip and send me the whole content of ASPRunner output

folder ( ASP files, include files, database etc.)? I'll find what's

wrong running it on my test box.
Best regards,

Sergey Kornilov