AnsweredAssumed Answered

Lua script DB connections for ORACLE DB

Question asked by Rajashekar Allala on Jun 13, 2018
Latest reply on Jul 6, 2018 by Rajashekar Allala

Hi All,

 

From the below tech tip, I can see there is DB connection provided for MSSQL and not for ORACLE database.

Tech Tip: UIM - correlating several alarms in the NAS 

 

We are using Oracle DB. What are the equivalent statements for below to connect to ORACLE DB and run the query?

 

database.open("Provider=SQLOLEDB;Initial Catalog=CA_UIM;Data Source=<databaseserver>,1433;User ID=sa;Password=<databasepassword>;Network Library=dbmssocn;Language=us_english")

database.query("select * from nas_alarms WITH (NOLOCK) where robot = '"..a.robot.."' and (message like '%total cpu is now%' or message like '%processor queue length%')")

Thank you.
Regards,
Rajashekar

Outcomes