I am having trouble getting alarm information into a SQL Server database that is located on the network. The information is being inserted somewhere, but not in the location that I am expecting. The alarm is being triggered from nas.
Thanks in advance.
-- -- Insert Alarm data into table for use in the Evolver Alert Monitor system -- -- Get triggering alarm new_alarm = alarm.get() -- This will open the default user database 'user.db' database.open("Data Source=myServer;Database=myDatabase;User ID=myId;Password=myPassword") -- Add rows to table database.query("INSERT INTO ALARMS (source) VALUES ('%s')", new_alarm.source); database.close()