PDA

View Full Version : Lianja sql server authentication



deepakrjx
2014-02-19, 21:31
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.

yvonne.milne
2014-02-20, 06:15
Hi deepakrjx,

The Lianja SQL Server uses the operating system user authentication/permissions. Specify a valid username and password for the server's host OS. You can also deny/allow connections based on ranges of or individual IP addresses in the Security settings of the Lianja Server Manager.

Regards,

Yvonne

deepakrjx
2014-02-20, 12:20
Thanks Yvonne. Connections work with username & password on the server's host OS.

Regards,

Deepak