Lianja sql server authentication
I am able to connect to the Lianja SQL Server using the connection string:
lcDSNLess="DRIVER=Lianja ODBC Driver;SERVER=?;DATABASE=southwind;Uid=?;Pwd=?"
The connection fails if I try :
lcDSNLess="DRIVER=Lianja ODBC Driver;SERVER=?;DATABASE=southwind;Uid=admin;Pwd=a dmin"
Also I tried adding records into the system!syroles table but that also did not work
lcDSNLess="DRIVER=Lianja ODBC Driver;SERVER=?;DATABASE=southwind;Uid=myname;Pwd= mypwd"
How and where do I add users into the LSQL server ?
I need to connect to remote LSQL server with UID+PWD authentication from other applications written in VFP / Excel / Python.