# I want to connect at Informix DB. Is there any idea?

**URL:** <https://discourse.nodered.org/t/i-want-to-connect-at-informix-db-is-there-any-idea/55329>\
**Category:** General\
**Tags:** database\
**Created:** [17 December 2021 06:18 UTC](https://discourse.nodered.org/t/i-want-to-connect-at-informix-db-is-there-any-idea/55329 "2021-12-17T06:18:20Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dumy](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dumy/32/50320_2.png) [@Dumy](https://discourse.nodered.org/u/Dumy)\
**Post date:** [17 December 2021 06:18 UTC](https://discourse.nodered.org/t/i-want-to-connect-at-informix-db-is-there-any-idea/55329/1 "2021-12-17T06:18:20Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![Dumy](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dumy/32/50320_2.png) [@Dumy](https://discourse.nodered.org/u/Dumy)\
**Post date:** [20 December 2021 06:57 UTC](https://discourse.nodered.org/t/i-want-to-connect-at-informix-db-is-there-any-idea/55329/2 "2021-12-20T06:57:08Z")

</div>

It's work for me

```auto
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();

```