Difference between revisions of "Connecting To AS400 / iSeries"

Revision as of 18:23, 12 January 2010

The settings for your SQL 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.

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.

@@ Line 11: / Line 11: @@
 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.
+  prompt=false tells it not to pop up a connection dialog (which is often undesired) if it can't connect.
 After hitting test and using the correct username and password you should see the following:-