• Search Forums
    Advanced Search
Prev
Next
Forums Infor / Lawson Platforms S3 Systems Administration

Database connection from SQL using Lawson service

 2 Replies
 0 Subscribed to this topic
 29 Subscribed to this forum
Sort:
Author
Messages
Chad Dirst
Advanced Member
Posts: 42
Advanced Member
New Poster
New Poster
Congrats on posting!
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
New Poster
New Poster
Congrats on posting!
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
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
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.