AS400 ODBC to JDBC
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.