Date:  10/06/2008 01:21:40 AM Msg ID:  003812
From:  jc clerc Thread:  003812
Subject:  Auth.AuthTable with any SQL server OK
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