# IBM AS400 Database connection **URL:** \ **Category:** Ignition\ **Created:** [March 10, 2010, 2:38pm UTC](https://forum.inductiveautomation.com/t/ibm-as400-database-connection/1619 "2010-03-10T14:38:46Z")\ **Posts on this page:** 10\ **Page:** 2
**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\ **Post date:** [March 17, 2010, 4:35pm UTC](https://forum.inductiveautomation.com/t/ibm-as400-database-connection/1619/21 "2010-03-17T16:35:53Z")
Thanks for helping out Bryan! Also, a great example of Stack Overflow to the rescue. ---
**Author:** ![bryan\_cook](https://avatars.discourse-cdn.com/v4/letter/b/a8b319/32.png) [@bryan\_cook](https://forum.inductiveautomation.com/u/bryan_cook)\ **Post date:** [March 17, 2010, 4:50pm UTC](https://forum.inductiveautomation.com/t/ibm-as400-database-connection/1619/22 "2010-03-17T16:50:44Z")
> [@Carl.Gould](#): > > Also, a great example of Stack Overflow to the rescue. Absolutely ... I sent an e-mail to a friend ... an hour or two later with no real response, I figured I'd just post the question on StackOverflow ... literally less than 2 minutes passed before I had an answer! ---
**Author:** ![jim\_lapratt](https://avatars.discourse-cdn.com/v4/letter/j/cc9497/32.png) [@jim\_lapratt](https://forum.inductiveautomation.com/u/jim_lapratt)\ **Post date:** [November 10, 2010, 2:54pm UTC](https://forum.inductiveautomation.com/t/ibm-as400-database-connection/1619/23 "2010-11-10T14:54:00Z")
Here is what I put in the “Default Validation Query” field. Select 1 from sysibm.sysdummy1 Thought this may help someone. I am now trying to get it to show different data library’s… Grrrrr ---
**Author:** ![bryan\_cook](https://avatars.discourse-cdn.com/v4/letter/b/a8b319/32.png) [@bryan\_cook](https://forum.inductiveautomation.com/u/bryan_cook)\ **Post date:** [November 12, 2010, 4:03pm UTC](https://forum.inductiveautomation.com/t/ibm-as400-database-connection/1619/24 "2010-11-12T16:03:23Z")
Curious … when you set up the driver, what translator did you use? ---
**Author:** ![jim\_lapratt](https://avatars.discourse-cdn.com/v4/letter/j/cc9497/32.png) [@jim\_lapratt](https://forum.inductiveautomation.com/u/jim_lapratt)\ **Post date:** [November 16, 2010, 12:45pm UTC](https://forum.inductiveautomation.com/t/ibm-as400-database-connection/1619/25 "2010-11-16T12:45:11Z")
The generic translator. It is connected fine. I am still working on this piece of the project as a whole. It got pushed way down the list, but its creeping back towards the top again… LOL ---
**Author:** ![jim\_lapratt](https://avatars.discourse-cdn.com/v4/letter/j/cc9497/32.png) [@jim\_lapratt](https://forum.inductiveautomation.com/u/jim_lapratt)\ **Post date:** [July 12, 2011, 1:49pm UTC](https://forum.inductiveautomation.com/t/ibm-as400-database-connection/1619/26 "2011-07-12T13:49:08Z")
What is the proper way to look at the JTOpen driver (JT400.JAR) and determine the version, so we know if there is an update needed? ---
**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\ **Post date:** [July 21, 2011, 8:51pm UTC](https://forum.inductiveautomation.com/t/ibm-as400-database-connection/1619/27 "2011-07-21T20:51:04Z")
If you open up jt400.jar in a good compression utility (I recommend 7-zip for windows), navigate to the META-INF directory and open up the MANIFEST.MF file in a text editor. You’ll find the JTOpen version in there. Looks like the current version is 7.4 ---
**Author:** ![jim\_lapratt](https://avatars.discourse-cdn.com/v4/letter/j/cc9497/32.png) [@jim\_lapratt](https://forum.inductiveautomation.com/u/jim_lapratt)\ **Post date:** [November 15, 2011, 1:16pm UTC](https://forum.inductiveautomation.com/t/ibm-as400-database-connection/1619/28 "2011-11-15T13:16:07Z")
Thought I would throw this out for info. When I updated to 7.3.1 I had to install the JTOPEN driver again. Then all worked fine. Not sure of cause 100% as I done some server upgrades at same time… Ya, I know… I know better then to do two updates at same time 😊 ---
**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\ **Post date:** [December 16, 2011, 6:54pm UTC](https://forum.inductiveautomation.com/t/ibm-as400-database-connection/1619/29 "2011-12-16T18:54:16Z")
By the way, the JDBC class is: com.ibm.as400.access.AS400JDBCDriver ---
**Author:** ![Ryan\_Shaw](https://avatars.discourse-cdn.com/v4/letter/r/dbc845/32.png) [@Ryan\_Shaw](https://forum.inductiveautomation.com/u/Ryan_Shaw)\ **Post date:** [May 18, 2023, 4:14pm UTC](https://forum.inductiveautomation.com/t/ibm-as400-database-connection/1619/30 "2023-05-18T16:14:17Z")
I was having this same problem today but the steps in this thread did not resolve it. What was missing was, I needed to create a new database translator under Databases -\> Drivers -\> Translators and configure it using the properties outlined in the Ignition user manual here: [https://docs.inductiveautomation.com/display/DOC81/JDBC+Driver+and+Database+Translator+Settings#JDBCDriverandDatabaseTranslatorSettings-IBMDefaultTranslatorSettings](https://docs.inductiveautomation.com/display/DOC81/JDBC+Driver+and+Database+Translator+Settings#JDBCDriverandDatabaseTranslatorSettings-IBMDefaultTranslatorSettings) The fields that were different from the default values were: Default Validation Query Auto Increment Field Definition Primary Key Syntax Limit Syntax Current Timestamp Query Supports Returning Auto-generated Keys? Fetch Key Query Datatype Mapping: Datetime, Binary, LongText Hope this helps! [Previous page](https://forum.inductiveautomation.com/t/ibm-as400-database-connection/1619.md?page=1)