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/

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.