Difference between revisions of "Connecting To AS400 / iSeries"
From PresenceWiki
(4 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
− | + | {{DatabaseConnectivityHeader}} | |
− | + | ||
+ | The settings for your AS400 Database Resource in Presence should be:- | ||
+ | |||
+ | [[file:as400details.png]] | ||
Note, the driver class is:- | Note, the driver class is:- | ||
Line 11: | Line 14: | ||
jdbc:as400://192.168.65.18;prompt=false;translate binary=true | 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. | + | prompt=false tells it <b>not</b> 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:- | After hitting test and using the correct username and password you should see the following:- | ||
− | + | [[file: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. | ||
− | + | [[file:as400results.png]] | |
+ | |||
+ | |||
+ | {{DatabaseConnectivityHeader}} |
Latest revision as of 13:21, 21 August 2015
Database Connectivity > Connecting To AS400 / iSeries |
The settings for your AS400 Database Resource in Presence should be:-
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:-
You can then use the Resource withing Presence in the SQL node.
Database Connectivity > Connecting To AS400 / iSeries |