Vester Support Portal (Matrikon, atvise, vNode)

// First define the ODBC connection in Windows

var odbcClient = new ODBCClient();

//------------details via http://www.connectionstrings.com/ .----------------------------------------------

odbcClient.source = "DSN=MySQL_ODBC; Uid=root; Pwd=DundasB1;"; // DNS, user and password of your database

if (odbcClient.open()) {    

//console.log ("ODBC Opend:", odbcClient.info());            //.info -> information of connected datasource

    try

    {

        var querytag = tagquery // define the Node we want to use to read the Query String from.

        var query = odbcClient.query(tagquery); // SQL query to bring the desired value from your database

        var value = []; //Create an array variable

        value.push(query[0][0]);//define las 2 partes del array y=0 x=0        

        //console.log("value is " +value);

        var timestamp = []; //Create an array variable

        timestamp.push(query[0][1]);//extract the second part of the array        

        //console.log("timestamp is " +timestamp);

        var node = new UaNode("AGENT.OBJECTS.Database_ARF.ValorResultado"); // Define the node that we want to assign the query result

        node.assign({value: value, sourcetime:new Date(timestamp)}); // Assign the query result to the node value

        //console.log(error);

        return(value);

        odbcClient.close();

    }

    catch (exp)

    {

        console.log(exp);

        if (exp.indexOf('No Data') > -1)

            return 0; // ok

        return undefined;

    }

    finally

    {

        if (odbcClient && odbcClient.opened == true)

            odbcClient.close();