Highlighted

ODBC connection to ISeries

New Here ,
Mar 20, 2018

Copy link to clipboard

Copied

Hello,

We are trying to setup a ODBC connection to an Iseries and we keep getting an error message when testing the connection. I have contacted coldfusion support and them had me change the port number but we still get that same error. We have contacted IBM and they have had us run trace routes to see if we could find the holdup but they dont even see the connection reach the DB. Has anyone else experienced this issue or know of a solution?

Views

401

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

ODBC connection to ISeries

New Here ,
Mar 20, 2018

Copy link to clipboard

Copied

Hello,

We are trying to setup a ODBC connection to an Iseries and we keep getting an error message when testing the connection. I have contacted coldfusion support and them had me change the port number but we still get that same error. We have contacted IBM and they have had us run trace routes to see if we could find the holdup but they dont even see the connection reach the DB. Has anyone else experienced this issue or know of a solution?

Views

402

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Mar 20, 2018 0
LEGEND ,
Mar 20, 2018

Copy link to clipboard

Copied

I know nothing of Iseries, or setting up CFServer to work with it, but a quick Google search found the following:

http://www.asadesigner.com/25-coldfusion/5a535a88fe0ba4be.htm

http://www.justskins.com/forums/add-as400-datasource-36843.html

http://coldfusion.sys-con.com/node/42109/mobile

I hope these are of use.

V/r,

^ _ ^

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Mar 20, 2018 0
Most Valuable Participant ,
Mar 20, 2018

Copy link to clipboard

Copied

In the past, I had more success using the JDBC driver for iSeries than using an ODBC connection.  The jt400.jar driver file is installed when the iSeries client software is installed, so you should be able to grab a copy from an PC running the iSeries client.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Mar 20, 2018 0