How to use an AS/400 connection?

[2005 IR Help]

By: Thorsten Hillebrand - matflasch

How to use an AS/400 connection?

2005-04-12 00:04

Hello,

 

I want to connect to an IBM AS/400 database with iReports. The jar-files are in /lib/ but i can't select the com.ibm.as400.access.AS400JDBCDriver -driver.

How could I get this connection and include the two jar-files?

 

Matflasch

 

 

 

 

By: Thorsten Hillebrand - matflasch

RE: How to use an AS/400 connection?

2005-04-12 02:37

Sorry... I use Windows 2000, /lib/ means iReportlib*.jar

The files in this dir are load on startup. But not my two jar-files.

 

I added the two jar-files to the classpath, but no change...

I could not use the AS400 connection.

 

Matflasch

 

 

 

 

By: janbal - anbal

RE: How to use an AS/400 connection?

2005-04-12 04:06

hi,

copy to jt400.jar in /lib

 

 

 

 

 

By: Thorsten Hillebrand - matflasch

RE: How to use an AS/400 connection?

2005-04-12 04:33

Hi,

 

I copied the two jar-files into the iReport-lib directory. Both files are in the CLASSPATH, but I could not choice the AS400-connection-class.

What can I do?

 

Thanks, Matflasch

 

 

 

 

By: janbal - anbal

RE: How to use an AS/400 connection?

2005-04-12 05:48

from connections/datasources create new connection

manually type in JDBC Driver's box com.ibm.as400.access.AS400JDBCDriver

..could not choice this class or i dont know to add this combobox.

 

 

 

 

By: Thorsten Hillebrand - matflasch

RE: How to use an AS/400 connection?

2005-04-12 05:55

'manually type the JDBC Driver's box....'

 

sorry! I didn't see, that I can type it manually....

Now it works!

 

Thanks!!

[mmariscal]

THANK YOU FOR THE "manually type in JDBC Driver's box ..." ADVICE!!