Connector between AS/400 - xMII

[Former Member]

Has anyone successfully sent a file from the AS/400 to xMII. Can I build a Datasource connector ?.

[jcgood25 · Accepted solution]

Yes we have several customers connecting to DB2. Here are some helpful links:

http://www-03.ibm.com/systems/i/software/toolbox/faqjdbc.html

http://www-03.ibm.com/systems/i/software/toolbox/downloads.html

You will be able to use the JTOpen jdbc driver, but it might be a good idea to ask the system dba for the version appropriate Type 4 JDBC driver file for you to upload to MII.

Once you have the jt400.jar file deployed onto the MII server, here are some helpful settings for the data server:

JDBCDriver: com.ibm.as400.access.AS400JDBCDriver

ServerURL: jdbc:as400://SystemName

Regards,

Jeremy

[Former Member · Accepted solution]

Has anyone had an experience with this ...

I have uploaded the jt400.jar file from the website.

But when I try to establish a connection, NW log displays a message 'Unable to establish connection'

I can ping to the AS/400 from the MII 12.0 server.

[Former Member · Accepted solution]

Shankar, can you give a little more detail about what you are trying to do?

[Former Member · Accepted solution]

Hi Christian,

I want to access the data from the AS/400 using the jdbc connector.

[Former Member · Accepted solution]

Thanks everyone. The problem was with the driver version that I was using in MII. Need to ensure that the Jt400.jar version is compatible with the version of the AS/400 O/S.

Also, AS/400 does not have a concept of database so need to enter the Library name from the AS/400 as the Database