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

Luxembourg

Luxembourg is only 2 hours from Paris with the new TGV Est so it was a relaxing trip when I went there on the weekend with Ferbent. We stayed at the new Novotel hotel which was great. I always try to stay in new hotels where possible as they are guaranteed to be clean and at €85 per night with breakfast included, I was really happy with it.

I was surprised that there were so many tourists around, especially from Greece it seemed. There were also lots of French, American, English, and Scandinavians. The usual suspects I guess.

What I loved most about Luxembourg is how everyone speaks each others language. So you can walk into a shop and start speaking French and then they'll switch to German or English or Portuguese or whatever language is required and they're happy to speak your language, not like in some other countries, ie. France.

I think everyone speaks English, French, German and Luxembourgish plus their own language if they are not originally from Luxembourg, as is the case with 50% of the population. Most seem to be of Portuguese or Italian origin.

There's not really much to do in Luxembourg. There are loads of cafes, restaurants, and beautiful parks. So all there is to do is sit around drinking and eating. That's my kind of holiday really. The shops were of no interest so we just took it easy, walking around the old city, and relaxing.

We spent 3 nights in Luxembourg which I'd say was too much. I was pretty bored towards the end and was happy to be returning home to Paris. I won't be going back but it was worth a quick visit.

View my photos of Luxembourg.