Difference between revisions of "Connecting To AS400 / iSeries"

From PresenceWiki
Jump to: navigation, search
 
(3 intermediate revisions by 2 users not shown)
Line 1: Line 1:
The settings for your SQL Database Resource in Presence should be:-
+
{{DatabaseConnectivityHeader}}
  
http://www.international-presence.com/images/docs/jdbc/sqlserverdetails.png  
+
 
 +
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 12: Line 15:
  
 
  prompt=false tells it <b>not</b> 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:-
  
http://www.international-presence.com/images/docs/jdbc/sqlconnect.png  
+
[[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.
  
http://www.international-presence.com/images/docs/jdbc/sqlresults.png
+
[[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:-

As400details.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 (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:-

As400connect.png

You can then use the Resource withing Presence in the SQL node.

As400results.png


Database Connectivity > Connecting To AS400 / iSeries