Easiest download link is here: https://ibm.biz/ibmi-odbc-download
You mentioned Linux but also mentioned Visual Studio, so I'm not sure what
platform you're running on (maybe your dev system is Windows, but
deployment is Linux?)
If you're on Windows (sounds like due to the VS reference), you'll need to
use cwbcfg to define a system:
After that you can create a DSN with ODBC Administrator (you can also skip
this step if you use a DSN-less connection string). On Linux, you don't
need to do this step.
These docs may also help:
For Node.js you'll want node-odbc:
. I believe there are now
pre-built Windows packages, but on Linux you'll need to compilers and
unixODBC development files installed in order for it to build when it is
----- Original message -----
From: "Vern Hamberg" <vhamberg@xxxxxxxxxxxxxxx>
Sent by: "OpenSource" <opensource-bounces@xxxxxxxxxxxxxxxxxx>
Subject: [EXTERNAL] Re: [IBMiOSS] How to access IBMi DB2 from an
external nodejs/express server
Date: Thu, Oct 14, 2021 8:09 AM
There is an ODBC package available for Linux - here is a link to
documentation from Information (Knowledge?) Center -
And this link has info and more links to get the Linux Application
I hope this helps!
On 10/14/2021 4:25 AM, Maria Lucia Stoppa wrote:
> Hi all,
> Though it might be quite a simple question, I am still struggling with
> and on the verge of giving up. Also, I researched the Opensource
> without success, which makes me feel as I am trying to do it the wrong
> That's the question: given a Nodejs application running Express on a
> server, easily and successfully callable from IBMi programs, how can I
> to it a new endpoint to read and write rows from/to my IBMi DB2
> Simply put: which Nodejs package can I use to access IBMi tables from
> external nodejs/express server?
> I found many packages that install on IBMi only, but I need the Nodejs
> application to run outside the IBMi server.
> Also, I tried node-jt400 package but it needs MS Visual Studio which I
> can't install on my development machine.
> Many sources talk about using ODBC, but I don't know where to start
> So, I finally resolve to ask for your experiences, if possible.
> Thank you very much for any hint or suggestion.
This is the IBMi Open Source Roundtable (OpenSource) mailing list
To post a message email: OpenSource@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: OpenSource-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
Help support midrange.com by shopping at amazon.com with our affiliate
As an Amazon Associate we earn from qualifying purchases.