Re: [IBMiOSS] How to access IBMi DB2 from an external nodejs/express server

Easiest download link is here: [1]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:
[2]https://www.ibm.com/support/pages/using-cwbcfg-utility-configure-ibm-i-access-client-solutions-windows-application-package-tcp-connections-multiple-users-and-services
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:
[3]https://ibmi-oss-docs.readthedocs.io/en/latest/odbc/installation.html#
 
For Node.js you'll want node-odbc:
[4]https://github.com/markdirish/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
installed.

----- Original message -----
From: "Vern Hamberg" <vhamberg@xxxxxxxxxxxxxxx>
Sent by: "OpenSource" <opensource-bounces@xxxxxxxxxxxxxxxxxx>
To: opensource@xxxxxxxxxxxxxxxxxx
Cc:
Subject: [EXTERNAL] Re: [IBMiOSS] How to access IBMi DB2 from an
external nodejs/express server
Date: Thu, Oct 14, 2021 8:09 AM
 
Lucia

There is an ODBC package available for Linux - here is a link to
documentation from Information (Knowledge?) Center -
[5]https://www.ibm.com/docs/en/i/7.4?topic=packages-linux-macos-pase-application

And this link has info and more links to get the Linux Application
Package -
[6]https://www.ibm.com/support/pages/ibm-i-access-client-solutions

I hope this helps!
Vern

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
it
> and on the verge of giving up. Also, I researched the Opensource
archive
> without success, which makes me feel as I am trying to do it the wrong
way.
>
> That's the question: given a Nodejs application running Express on a
Linux
> server, easily and successfully callable from IBMi programs, how can I
add
> to it a new endpoint to read and write rows from/to my IBMi DB2
tables?
> Simply put: which Nodejs package can I use to access IBMi tables from
an
> 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
from.
>
> So, I finally resolve to ask for your experiences, if possible.
>
> Thank you very much for any hint or suggestion.
>
> Lucia
>

--
This is the IBMi Open Source Roundtable (OpenSource) mailing list
To post a message email: OpenSource@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: [7]https://lists.midrange.com/mailman/listinfo/opensource ;
or email: OpenSource-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at [8]https://archive.midrange.com/opensource ;.

Help support midrange.com by shopping at amazon.com with our affiliate
link: [9]https://amazon.midrange.com ;

 

References

Visible links
1. https://ibm.biz/ibmi-odbc-download
2. https://www.ibm.com/support/pages/using-cwbcfg-utility-configure-ibm-i-access-client-solutions-windows-application-package-tcp-connections-multiple-users-and-services
3. https://ibmi-oss-docs.readthedocs.io/en/latest/odbc/installation.html#
4. https://github.com/markdirish/node-odbc
5. https://www.ibm.com/docs/en/i/7.4?topic=packages-linux-macos-pase-application
6. https://www.ibm.com/support/pages/ibm-i-access-client-solutions
7. https://lists.midrange.com/mailman/listinfo/opensource
8. https://archive.midrange.com/opensource
9. https://amazon.midrange.com/