Node-red is installed on a windows server 2012. How can I connect to the Informix database?
I did not find any available node or ODBC with windows. Can I do this by function?
It's work for me
const odbc = global.get("odbc");
async function queryAccess() {
const connection = await odbc.connect(`DSN=;UID=;PWD=`);
const data = await connection.query(''+msg.sql+'');
msg.payload = data;
return msg;
}
return queryAccess();
1 Like