Who's On?

	Membership:
	Latest: Saef
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5226

	People Online:
	Visitors: 504
	Members: 0
	Total: 504

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1372
Roger French	1315
mark.cook	1244

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

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

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

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.