-
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.
-
Lianja Team
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
-
Thanks Yvonne. Connections work with username & password on the server's host OS.
Regards,
Deepak
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
Bookmarks