we have an database which we want to use a lua script to access and to run a stored procedure against and add the returned data to a note on a alarm.
we are having issues in opening the connection.
al = alarm.list ()
database.open("Provider=SQLOLEDB;Initial Catalog=database_name;Data Source=Database server;Network Library=dbmssocn;Language=us_english;Integrated Security=SSPI")
rs = database.query("exec storedproc + parameters")
code to add the data to the note