Difference between revisions of "Connecting To AS400 / iSeries"
From PresenceWiki
Line 11: | Line 11: | ||
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 if it can't connect | + | prompt=false tells it not to pop up a connection dialog if it can't connect which is often 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:21, 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 which is often 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