Results 1 to 3 of 3

Thread: Lianja sql server authentication

  1. #1
    Junior Member
    Join Date
    Jul 2013
    Posts
    6

    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.

  2. #2
    Lianja Team yvonne.milne's Avatar
    Join Date
    Feb 2012
    Location
    Berkshire, UK
    Posts
    1,380
    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

  3. #3
    Junior Member
    Join Date
    Jul 2013
    Posts
    6
    Thanks Yvonne. Connections work with username & password on the server's host OS.

    Regards,

    Deepak

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us