JDBC driver installation

[Former Member]

Hi,

I am trying to configure my JDBC adatpter to connect from my PI 7.0 system on windows 2003 / MSSQL 2005 to our AS/400 / DB2. Does anyone know what drivers I need to download and instructions on how to configure the adapter?

Thanks,

Lee

[Former Member · Accepted solution]

Nisar,

The first link does not get me to a download driver page and I wasn't able to find the JDBC drivers there. I'll keep looking.

The second link you posted gave me a 404. Can you correct the link and repost?

Thanks,

Lee

[nisarkhan_n · Accepted solution]

sorry about that.....

to delopy the driver check this link, download the zip file this zip file has the tool and PDF on how to deploy.....

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/bf4b1055-0d01-0010-32a3-b3848d77...

check this link for jar files:

http://www.ibm.com/developerworks/db2/downloads/jcc/

Message was edited by:

n Khan

[justin_santhanam · Accepted solution]

Lee,

You need Jt400.jar file.

@Khan are u sure with the .jar files provided.

raj.

[nisarkhan_n · Accepted solution]

Lee,

My apologies...it is JT400.jar.....use the link to deploy the driver.......u might find the link in this article

http://publib.boulder.ibm.com/infocenter/wasinfo/v6r0/index.jsp?topic=/com.ibm.websphere.express.doc...

raj....

thank you for pointing, my mistake....just misread db2 .....

[Former Member]

Thanks Guys. I got the adapter working.

[nisarkhan_n]

Download universal driver for DB2,the jar file

http://www-128.ibm.com/developerworks/db2/library/techarticle/0203zikopoulos/0203zikopoulos.html

also have a look at the following to install these driver in XI

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/xi/xi-how-to-guide...

These are the connection parameters for this:

JDBC Driver: com.ibm.as400.access.AS400JDBCDriver

Connection :jdbc:as400://ServerName/databaseName

i think you need these files to deploy, download this from the IBM site.

db2jcc.jar

db2jcc_license_c.jar

regards

Nisar

Message was edited by:

n Khan

Message was edited by:

n Khan