AS400 ODBC to JDBC

[avdk003]

Hello, I am trying to connect to an AS400 on Knime.
This is the connection url I wrote in Python that works.

conn = pyodbc.connect(
"Driver={iSeries Access ODBC Driver}; "
"System=ABC01; "
"Hostname=AB.ABC.ABC.AB; "
"Port=XXX; "
"Force Translate=False; "
"trusted_connection=yes; "
)
The driver I am using in my juypter notebook is CWBODBC.DLL version 07.01.027.

I am not sure how to turn this into a connection string for a JDBC driver on Knime. Here is what I tried in Knime and the driver I think I am supposed to use.

Any help would be appreciated thanks.

[mlauber71]

@avdk003 welcome to the KNIME forum. There was this hint posted:

Error Connetion to DataBase AS400!!

We had problems also trying to connect. We were using the wrong driver. We succeeded with the following config and the driver jt400.jar: [image] [image] Note that in the Database URL the address should be jdbc:as400:your servere address NO “//” there.

[avdk003]

Hi,
I got this fixed. It turns out the solution was to use this as the connection url:
jdbc:as400:

and that’s it. The IBM Iseries Access Client that manages connections uses several ports. When I specified a port I was only connecting to one of those services.

I also add a simply validation query in the advanced tab of the DB connector (ie; Select 1 from table).

Thanks for your help.