## Where communities thrive

• Join over 1.5M+ people
• Join over 100K+ communities
• Free without limits
##### Activity
• Jan 30 2019 15:14
trendzetter starred nukedzn/node-informix
• Jan 30 2019 15:14
trendzetter starred nukedzn/node-informix
• Jan 19 2019 23:45
lyonmerc opened #62
• Jan 16 2019 13:54
• Jan 15 2019 03:15
• Dec 25 2018 23:02
uditha-atukorala closed #39
• Dec 25 2018 23:02
uditha-atukorala commented #39
• Dec 25 2018 22:54

uditha-atukorala on v1.0.0

• Dec 25 2018 22:54

uditha-atukorala on master

version 1.0.0 (compare)

• Dec 25 2018 22:51

uditha-atukorala on cleanup

• Dec 25 2018 22:51

uditha-atukorala on master

fix buffer memory deallocation drop unnecessary header inclusi… code cleanup - whitespaces and 3 more (compare)

• Dec 25 2018 22:51
uditha-atukorala closed #61
• Dec 25 2018 22:51
codecov-io commented #61
• Dec 25 2018 22:50
codecov-io commented #61
• Dec 25 2018 22:49
uditha-atukorala opened #61
• Dec 25 2018 22:49

uditha-atukorala on cleanup

code cleanup - whitespaces cleanup buffer memory allocation updated dependencies (compare)

• Dec 25 2018 22:18

uditha-atukorala on cleanup

fix buffer memory deallocation drop unnecessary header inclusi… (compare)

• Dec 19 2018 10:40

uditha-atukorala on master

Add TEXT support Fix test Fix test and 1 more (compare)

• Dec 19 2018 10:40
uditha-atukorala closed #59
• Dec 09 2018 00:18
RobbieClarken starred nukedzn/node-informix
Uditha Atukorala
@uditha-atukorala
We have connection pools now :smile:
Uditha Atukorala
@uditha-atukorala
I think it is working OK, but if someone else could double check that would be great!!!
Uditha Atukorala
@uditha-atukorala
can’t seem to figure out the root cause for #31 :worried:
SaravananVT
@SaravananVT
I am trying to install nodejs client for informix and getting some errors
can somebody help
Uditha Atukorala
@uditha-atukorala
Hi, what sort of errros are you getting?
If you can give me more details, I’ll try to help…
SaravananVT
@SaravananVT

npm install informix
|

informix@0.5.2 install /Users/saravanantirugnanum/node_modules/informix
node-gyp rebuild

gyp: Call to 'THREADLIB=POSIX esql -static -thread -libs' returned exit status 127. while trying to load binding.gyp
gyp ERR! configure error
gyp ERR! stack Error: gyp failed with exit code: 1
gyp ERR! stack at ChildProcess.onCpExit (/usr/local/lib/node_modules/npm/node_modules/node-gyp/lib/configure.js:357:16)
gyp ERR! stack at ChildProcess.emit (events.js:110:17)
gyp ERR! stack at Process.ChildProcess._handle.onexit (child_process.js:1074:12)
gyp ERR! System Darwin 15.4.0
gyp ERR! command "node" "/usr/local/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js" "rebuild"
gyp ERR! cwd /Users/saravanantirugnanum/node_modules/informix
gyp ERR! node -v v0.12.2
gyp ERR! node-gyp -v v2.0.2
gyp ERR! not ok
npm ERR! Darwin 15.4.0
npm ERR! argv "node" "/usr/local/bin/npm" "install" "informix"
npm ERR! node v0.12.2
npm ERR! npm v2.14.2
npm ERR! code ELIFECYCLE

npm ERR! informix@0.5.2 install: node-gyp rebuild
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the informix@0.5.2 install script 'node-gyp rebuild'.
npm ERR! This is most likely a problem with the informix package,
npm ERR! not with npm itself.
npm ERR! Tell the author that this fails on your system:
npm ERR! node-gyp rebuild
npm ERR! You can get their info via:
npm ERR! npm owner ls informix
npm ERR! There is likely additional logging output above.

npm ERR! Please include the following file with any support request:
npm ERR! /Users/saravanantirugnanum/npm-debug.log

Uditha Atukorala
@uditha-atukorala
looks like it can’t find esqlc, do you have informix client SDK installed and the paths set correctly?
take a look at https://github.com/nukedzn/node-informix#dependencies and check you have the environment variables set correctly as well
@coderroggie
I'm running a fairly simple query that returns a few columns that are of type Decimal in the database. It looks like the results are returned as integers though... is there a way to fix that?
Uditha Atukorala
@uditha-atukorala
hey @coderroggie, it is possible that this is a bug
could you please raise an issue in github with details and I’ll take a look :smile:
@coderroggie
@uditha-atukorala thanks for the response, but i got (https://www.npmjs.com/package/ibm_db) working which seems to work for the aforementioned issue. Thanks!'
Henry Quinn
@Quinncuatro
I don't see in the documentation anything about connecting to a remote server
Is there a host field that we can add to the opts object?
Elias Karakoulakis
@ekarak
IIRC there's a sqlhosts file that's where you define the actual Informix server hostname
Raghu Muniyal
@muniyalr
@uditha-atukorala the informix installation requires the compilation of g++ without which i cannot get it installed. Do i need to have the gcc installed on the production servers if need to use informix node module or is there other way of installing the same without having to install the build packages
Uditha Atukorala
@uditha-atukorala
@muniyalr, if you do npm install on a different box (with the same arch and OS/libs ofc) and then copy node_modules/* to the production box that should work.
Raghu Muniyal
@muniyalr
@uditha-atukorala Thanks will do a build on different box/container and copy the files to production boxes..
Mceee
@Mceee
@uditha-atukorala hi. I tried to install the driver on centos 7 with node js 10.13.0. I am using the CSDK 4.10FC11 for esql. The esql command works fine but I also got an error installing the package with npm. After some tests, I got the impression, that the -thread parameter was the problem. For that reason I removed the parameter from the source to see if the installation would work afterwards. It worked! But now I've got the next problem after trying to run a query: "node: symbol lookup error: /home2/downloads/informix/infx/build/Release/ifx.node: undefined symbol: ifx_sqlcode".
Uditha Atukorala
@uditha-atukorala
@Mceee Hey, I haven’t testing this with Node 10, I’ll take a look.
Mceee
@Mceee
thanks, that would be great!
Mceee
@Mceee
Did you already have a chance to look into it?
Uditha Atukorala
@uditha-atukorala
Hey @Mceee, sorry have been extremely busy but I’m hoping to look into this within the next few days.
Uditha Atukorala
@uditha-atukorala
@Mceee, sorry for not looking into this sooner… I did a quick check and apart from warnings (due to outdated dependencies) it seems to work ok with Node v10. Not on centos 7 thought, didn’t have one I could access easily.
Can you check whether you need to patch esql please (https://github.com/nukedzn/node-informix/blob/master/esql-4.10.debian.patch) ? On debian/ubuntu -thread caused issue due to a bug in esql. Worth checking that.
Mceee
@Mceee
Ok, thank you! I will try the patch and respond. Which distribution does work for you with Node v10?
Uditha Atukorala
@uditha-atukorala
Only got to check on Mac but should be the same on other Linux distros (including CentOS)
Mceee
@Mceee
Ah ok!
Mceee
@Mceee
Hey, unfortunately the patch didn't work for CentOS but I tried Debian and it works just fine! Thank you! We want to build our new backend on Node and our Database is on Informix. And of course we don't want to use ODBC...
Uditha Atukorala
@uditha-atukorala
Awesome! good to hear you got it working. Just a note, currently large objects aren’t supported (e.g. #39, #40) and it needs some work to get it working.
Mceee
@Mceee
@uditha-atukorala That is no problem for us. But I have another issue. Do you think it is possible to retrieve the column names within the results array? I have looked into the source but I am not too familiar with ESQL and it seems possible to use the field references with the fetch statement but I can't imagine what the result would look like.
Jalal Albasri
@JalalAlbasri
Can I use this to connect to an Informix database remotely?
Uditha Atukorala
@uditha-atukorala
yes, this uses configs in sqlhosts and you’ll have to configure your remote connection (https://www.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.sqlr.doc/ids_sqr_268.htm)
@Mceee, in theory it is possible (Informix CLI does it which uses ESQL/C) but it needs some code changes to get it working (iirc)
Trendzetter
@Trendzetter_gitlab
hi everyone!
I am so happy I found this informix driver for node!
I have one question after first usage
I am trying to get some feedback from an update query
But it seems there is nothing indicating if or how many rows were affected.
is there a way to get a response from update?
Trendzetter
@Trendzetter_gitlab
I am updating tag reader codes from a webpage and I want to provide feedback when no code to update was found. I could select, update and select again but maybe that is too farfetched?\$
Gajendrasinh Zala
@Gajendrasinh

Hello Everyone,

I have installed this : npm install --save informix

getting below error

error: uncaughtException: Could not locate the bindings file. Tried:
→ DemoProject\node_modules\informix\build\ifx.node
→ DemoProject\node_modules\informix\build\Debug\ifx.node
→ DemoProject\node_modules\informix\build\Release\ifx.node
→ DemoProject\node_modules\informix\out\Debug\ifx.node
→ DemoProject\node_modules\informix\Debug\ifx.node
→ DemoProject\node_modules\informix\out\Release\ifx.node
→ DemoProject\node_modules\informix\Release\ifx.node
→ DemoProject\node_modules\informix\build\default\ifx.node
→ DemoProject\node_modules\informix\compiled\10.16.0\win32\x64\ifx.node
→ DemoProject\node_modules\informix\lib\binding\node-v64-win32-x64\ifx.node

Gajendrasinh Zala
@Gajendrasinh
info: Server Started, and Listening on port 8006...
{ [Error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified]
errors: [],
error: '[node-ifxnjs] SQL_ERROR',
message:
'[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified',
state: 'IM002' }
Gajendrasinh Zala
@Gajendrasinh

@SaravananVT Hello

I am also getting same error can you help me to fixed this issue.

Trendzetter
@Trendzetter_gitlab
@Gajendrasinh This is a native informix driver. For ODBC I think you will need to correctly define the datasource first (not sure, I am not using odbc for informix). You probably need a different driver: https://github.com/OpenInformix/IfxNode
Please show me how to get feedback from an update using this driver. I am using the promise (.then keyword after .query) and catch the exception using .catch(function (err: any) { console.log('error:' +err);}
Trendzetter
@Trendzetter_gitlab
but I am not getting any error when the query fails or how many rows have been updated