Difference between revisions of "Connecting To AS400 / iSeries"
Line 1: | Line 1: | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
The settings for your SQL Database Resource in Presence should be:- | The settings for your SQL Database Resource in Presence should be:- | ||
Line 14: | Line 4: | ||
Note, the driver class is:- | Note, the driver class is:- | ||
− | com. | + | 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:- | The connection URL takes the form:- | ||
− | jdbc: | + | jdbc:as400://192.168.65.18;prompt=false;translate binary=true |
− | + | prompt=false tells it not to pop up a connection dialog if it can't connect. | |
− | + | If this is excluded, then each time the connection fails due to authentication a dialog will appear, | |
+ | which is usually unwanted. | ||
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:- | ||
Line 35: | Line 21: | ||
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/sqlresults.png | + | http://www.international-presence.com/images/docs/jdbc/sqlresults.png |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + |
Revision as of 18:19, 12 January 2010
The settings for your SQL Database Resource in Presence should be:-
http://www.international-presence.com/images/docs/jdbc/sqlserverdetails.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 if it can't connect. If this is excluded, then each time the connection fails due to authentication a dialog will appear, which is usually unwanted.
After hitting test and using the correct username and password you should see the following:-
http://www.international-presence.com/images/docs/jdbc/sqlconnect.png
You can then use the Resource withing Presence in the SQL node.
http://www.international-presence.com/images/docs/jdbc/sqlresults.png