Prev
Next
Forums Infor / Lawson Platforms S3 Systems Administration

Database connection from SQL using Lawson service

 2 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
Chad Dirst
Advanced Member
Posts: 42
Advanced Member
2/5/2014 1:28 PM
    I am curious if anyone is connecting to their database from a unix/sql script via the Lawson database service they have defined in ssoconfig.

    if so, can you please provide the syntax you are using.
    Thank you.
    Chad
    Chad Dirst
    Advanced Member
    Posts: 42
    Advanced Member
    2/10/2014 3:02 PM
      If not one is connecting to the database via the service they have defined in ssoconfig is anyone familar with how I can run a sql on a schedule (say weekly) without hard coding a password in a file.
      Thanks.
      Ari
      Veteran Member
      Posts: 49
      Veteran Member
      2/27/2014 9:15 PM
        Well, on Windows with the Lawson Database in SQL Sever, I connect to the Database using SQLCMD. I code SQL statements into a batch file and schedule it. If the user running the batch file has access to the Lawson Database then I don't need to code the ID and Password in the SQLCMD command.