Difference between revisions of "Connecting To AS400 / iSeries"
Line 1: | Line 1: | ||
− | The settings for your | + | The settings for your AS400 Database Resource in Presence should be:- |
− | http://www.international-presence.com/images/docs/jdbc/ | + | http://www.international-presence.com/images/docs/jdbc/as400details.png |
Note, the driver class is:- | Note, the driver class is:- | ||
Line 19: | Line 19: | ||
After hitting test and using the correct username and password you should see the following:- | After hitting test and using the correct username and password you should see the following:- | ||
− | http://www.international-presence.com/images/docs/jdbc/ | + | http://www.international-presence.com/images/docs/jdbc/as400connect.png |
You can then use the Resource withing Presence in the SQL node. | You can then use the Resource withing Presence in the SQL node. | ||
− | http://www.international-presence.com/images/docs/jdbc/ | + | http://www.international-presence.com/images/docs/jdbc/as400results.png |
Revision as of 11:29, 27 January 2010
The settings for your AS400 Database Resource in Presence should be:-
http://www.international-presence.com/images/docs/jdbc/as400details.png
Note, the driver class is:- com.ibm.as400.access.AS400JDBCDriver
Which can be found in the jt400.jar which is included in the presence install
The connection URL takes the form:- jdbc:as400://192.168.65.18;prompt=false;translate binary=true
prompt=false tells it not to pop up a connection dialog (which is often undesired) if it can't connect.
For an extensive list of properties see:-
http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/rzahh/javadoc/JDBCProperties.html
After hitting test and using the correct username and password you should see the following:-
http://www.international-presence.com/images/docs/jdbc/as400connect.png
You can then use the Resource withing Presence in the SQL node.
http://www.international-presence.com/images/docs/jdbc/as400results.png