Connecting Coldfusion to an AS400

Just so I don't forget next time my computer dies, here is a record of how to set up Coldfusion to connect to an AS400 or iSeries database.

Login to Coldfusion Administrator

http://127.0.0.1:8500/CFIDE/administrator/index.cfm

Password: *********

Data and Services > Data Sources:

Data Source Name: anyName

Driver: other

CF Data Source Name: anyName

JDBC URL: jdbc:as400://[database ip address]/

Driver Class: com.ibm.as400.access.AS400JDBCDriver

Username: username

Password: ********

Save the jt400.jar driver in the Coldfusion directory:

C:/CFusionMX7/lib/jt400.jar

Add this class path to Coldfusion:

Server Settings > Java and JVM

Coldfusion Class Path:

C:/CFusionMX7/lib/jt400.jar

Submit Changes

Restart the Coldfusion service:

Control Panel > Administrative Tools > Services

Verify the class path:

Server Settings > Settings Summary

Check the last entry in CF Server Java Class Path

Verify the connection