Re: [IBMiOSS] ODBC

Okay, apparently I am just impatient. If I use this code, it works both
from the PC attaching to the IBM i and also running natively within the IBM
i:

/*jshint esversion: 6 */
const odbc = require('odbc');
const cn = "DRIVER=IBM i Access ODBC
Driver;SYSTEM=systemname;UID=username;PWD=userpassword";
odbc.connect(cn , (error, connection) => {
if (error) {
throw error;
}
connection.query('SELECT * FROM myschema.mytable', (error, result) => {
if (error) {
throw error;
}
console.log(result);
}
);
});

So, now my question is slightly different - from the PC the reply time is
relatively short (20 seconds or so), but within the IFS the reply time is
closer to 1 1/2 minutes. Why does the internally running code take longer?
I would have expected this reversed.

Thanks,
Steve

-----Original Message-----
From: OpenSource <opensource-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Jon
Paris
Sent: Thursday, August 6, 2020 14:52
To: IBMi Open Source Roundtable <opensource@xxxxxxxxxxxxxxxxxx>
Subject: Re: [IBMiOSS] ODBC

I found King's piece on installing ODBC for Python on IBM i to be useful and
that combined with Jack's reference gave me what I needed.

You can find it here https://odbcphp.k3s.com/ <https://odbcphp.k3s.com/> if
you haven't already found it.

On Aug 6, 2020, at 10:51 AM, Jack Woehr <jwoehr@xxxxxxxxxxxxxxxxxxxxxxxx>

wrote:

On Thu, Aug 6, 2020 at 7:29 AM Steve M via OpenSource <
opensource@xxxxxxxxxxxxxxxxxx> wrote:

Background, I started with this page,
https://github.com/IBM/ibmi-oss-examples/blob/master/odbc/odbc.md.
The driver is successfully installed from the ACS download page, on my

IBM i.

When I run "odbcinst -j" I have:

If you don't get an answer here, ask on the IBM i Open Source group at
https://ibmioss.ryver.com/ in the Database forum.

The self-enroll link is
https://ibmioss.ryver.com/application/signup/members/9tJsXDG7_iSSi1Q

--
Jack Woehr
Absolute Performance, Inc.
12303 Airport Way, Suite 100
Broomfield, CO 80021

NON-DISCLOSURE NOTICE: This communication including any and all
attachments is for the intended recipient(s) only and may contain
confidential and privileged information. If you are not the intended
recipient of this communication, any disclosure, copying further
distribution or use of this communication is prohibited. If you
received this communication in error, please contact the sender and
delete/destroy all copies of this communication immediately.
--
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: https://lists.midrange.com/mailman/listinfo/opensource
or email: OpenSource-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/opensource.

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

--
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: https://lists.midrange.com/mailman/listinfo/opensource
or email: OpenSource-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/opensource.

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