Benjamin J Ferguson

I also see poor performance vs other connectors (ex: JDBC). Performance seems fine when the code runs on power, but when using odbc on my pc, it's painfully slow. I...

Hello @kadler ! For jdbc, we are using this npm package: https://www.npmjs.com/package/jdbc It uses a jt400.jar to connect to an ibm db2 database. Our server admin, Mike Bohlen from Duncan...

Yes, my connection string looks like this... let connectionString = `Driver={IBM i Access ODBC Driver}; Naming=1; System=${process.env.dbName}; Uid=${process.env.dbId}; Pwd=${process.env.dbPw}`;

@kadler Are you asking for a network trace?

@kadler I was able to do an odbc trace following the instructions on the npm site: https://www.npmjs.com/package/odbc `Open up ODBC Data Source Administrator and select the "Tracing" tab. Enter the...

Ok, I've attached a trace. I'm running a simple sql statement: "select * from [table] limit 100". When the trace is off, this statement runs in 9-10 seconds. With the...

@kadler I was able to get an odbc trace with a call in it. I increased my connection timeout and went to lunch, lol. It took a looooong time, but...

@kadler I've got a jdbc trace! One difference between the jdbc and odbc traces is that we are using jdbc to start up our local server. You'll see a couple...

@kadler We are running both idbc and odbc from a pc and hitting a server remotely. Our current set up is to connect to a db2 database with jdbc from...

@kadler That sounds promising. Thank you for checking on it! If you decide to change that behavior, I would be happy to test it out.