View Complete Thread | FoxWeb Forum Home
Search:
Date:    Msg ID:   
From:    Thread:   
Subject:   
Hello,
After the immediate reply from the foxweb team (thanks a lot) I have tried to simply connect to my sql server (in my case Mysql) and created a cursor in order to get the user table and it works perfectly :
 
mysql= SQLSTRINGCONNECT('dsn=mysql;uid=youruser;pwd=yourpassword')
SQLEXEC(mysql,"select name,password from usertable","users")
Auth.AuthTable = "users"
Auth.AuthformFile="AuthForm.fwx"
Auth.Useridfieldname="name"
Auth.Passwordfieldname="password"
Auth.SaveCookie = 1
Auth.Authenticate()

Simple as that !
 
JC