Difference between revisions of "Connecting To AS400 / iSeries"
Line 12: | Line 12: | ||
prompt=false tells it not to pop up a connection dialog if it can't connect. | prompt=false tells it not to pop up a connection dialog if it can't connect. | ||
− | + | Failure to include this parameter will result in an authentication dialog appearing if it can't connect | |
− | + | This is usually undesired. | |
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:- |
Revision as of 18:20, 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. Failure to include this parameter will result in an authentication dialog appearing if it can't connect This is usually undesired.
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