# AS400 Database Connection **URL:** \ **Category:** Ignition\ **Tags:** ignition79\ **Created:** [February 22, 2019, 12:26pm UTC](https://forum.inductiveautomation.com/t/as400-database-connection/22800 "2019-02-22T12:26:18Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![c.bertulli](https://avatars.discourse-cdn.com/v4/letter/c/f19dbf/32.png) [@c.bertulli](https://forum.inductiveautomation.com/u/c.bertulli)\ **Post date:** [February 22, 2019, 12:26pm UTC](https://forum.inductiveautomation.com/t/as400-database-connection/22800/1 "2019-02-22T12:26:18Z")
Hi All, I need some help setting up a connection to an AS400 in Ignition. I’ve read this post [IBM AS400 Database connection](http://forum.inductiveautomation.com/t/ibm-as400-database-connection/1619?u=c.bertulli) but I still can’t get a valid connection ☹ In order to have a connection: Do I have to create a new Database Drivers (Setting - Drivers - Database Drivers & Settings) or the IBM DB2 Driver would be ok? ---
**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Post date:** [February 22, 2019, 1:06pm UTC](https://forum.inductiveautomation.com/t/as400-database-connection/22800/2 "2019-02-22T13:06:29Z")
Try this [link](https://support.inductiveautomation.com/index.php?/Knowledgebase/Article/View/120/0/connecting-to-ibm-as400-iseries-database) from IA knowledge base. I used this a while back and it worked for me. ---
**Author:** ![c.bertulli](https://avatars.discourse-cdn.com/v4/letter/c/f19dbf/32.png) [@c.bertulli](https://forum.inductiveautomation.com/u/c.bertulli)\ **Post date:** [February 22, 2019, 1:39pm UTC](https://forum.inductiveautomation.com/t/as400-database-connection/22800/3 "2019-02-22T13:39:02Z")
Well, this is helpful! A lot! 👍 But still can’t get a connection, can someone explain to me how the connection URL should be done? `jdbc:as400://IPorHOSTNAME/Schema` **jdbc:as400** this part is standard and I get it. **//IPorHOSTNAME/Schema** this part? ---
**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Post date:** [February 22, 2019, 1:54pm UTC](https://forum.inductiveautomation.com/t/as400-database-connection/22800/4 "2019-02-22T13:54:28Z")
This is how mine is setup. Our IT department did this part, so I can’t advise you any more than that. `jdbc:as400://iseries.cfc.local/Schema` ---
**Author:** ![Sanderd17](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/sanderd17/32/8735_2.png) [@Sanderd17](https://forum.inductiveautomation.com/u/Sanderd17)\ **Post date:** [February 22, 2019, 1:57pm UTC](https://forum.inductiveautomation.com/t/as400-database-connection/22800/5 "2019-02-22T13:57:24Z")
> [@c.bertulli](#): > > But still can’t get a connection Watch out, a DB is only considered "connected" by Ignition when the validation query returns a result. Did you set it to `select 1 from sysibm.sysdummy1` as described in the article? A simple `SELECT 1` won't work for DB2. ---
**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Post date:** [February 22, 2019, 2:02pm UTC](https://forum.inductiveautomation.com/t/as400-database-connection/22800/6 "2019-02-22T14:02:55Z")
> [@Sanderd17](#): > > Did you set it to `select 1 from sysibm.sysdummy1` as described in the article? This is how I have my connection configured, so yes it is needed. ---
**Author:** ![c.bertulli](https://avatars.discourse-cdn.com/v4/letter/c/f19dbf/32.png) [@c.bertulli](https://forum.inductiveautomation.com/u/c.bertulli)\ **Post date:** [February 22, 2019, 2:08pm UTC](https://forum.inductiveautomation.com/t/as400-database-connection/22800/7 "2019-02-22T14:08:21Z")
Yes, I have done everything as the article says. The only thing that concern me is the URL connection… ---
**Author:** ![c.bertulli](https://avatars.discourse-cdn.com/v4/letter/c/f19dbf/32.png) [@c.bertulli](https://forum.inductiveautomation.com/u/c.bertulli)\ **Post date:** [February 22, 2019, 2:19pm UTC](https://forum.inductiveautomation.com/t/as400-database-connection/22800/8 "2019-02-22T14:19:43Z")
> [@dkhayes117](#): > > jdbc:as400://iseries.cfc.local/Schema Do you know what **iseries** , **cfc** , **local** mean? Are they 3 separated fields or just one? ---
**Author:** ![c.bertulli](https://avatars.discourse-cdn.com/v4/letter/c/f19dbf/32.png) [@c.bertulli](https://forum.inductiveautomation.com/u/c.bertulli)\ **Post date:** [February 22, 2019, 2:39pm UTC](https://forum.inductiveautomation.com/t/as400-database-connection/22800/9 "2019-02-22T14:39:56Z")
Found it! 🎊🎉 I’m so dumb! IPorHOSTNAME is IP **or** HOSTNAME! `jdbc:as400://IPaddress/Schema` and if you want a specific library you have to add `libraries=YourLibrary` to the **Extra Connection Properties** I got a valid connection! Thanks to all! ---
**Author:** ![uy\_huynh](https://avatars.discourse-cdn.com/v4/letter/u/54ee81/32.png) [@uy\_huynh](https://forum.inductiveautomation.com/u/uy_huynh)\ **Post date:** [August 26, 2025, 6:34am UTC](https://forum.inductiveautomation.com/t/as400-database-connection/22800/10 "2025-08-26T06:34:41Z")
Hi guys, How do you interact with As400 via Ignition? I have valid connection with it, but can’t see any schema/library with the database query browser. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/2/926c36c8219a4a686d0de649ce3bc15cdb7dbf2b.png) ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [August 26, 2025, 12:11pm UTC](https://forum.inductiveautomation.com/t/as400-database-connection/22800/11 "2025-08-26T12:11:59Z")
That is a function of the JDBC driver and the privileges granted to the connection. You might find suggestions via web search, but you might also have to operate blind in the designer. ---
**Author:** ![uy\_huynh](https://avatars.discourse-cdn.com/v4/letter/u/54ee81/32.png) [@uy\_huynh](https://forum.inductiveautomation.com/u/uy_huynh)\ **Post date:** [August 26, 2025, 10:43pm UTC](https://forum.inductiveautomation.com/t/as400-database-connection/22800/12 "2025-08-26T22:43:12Z")
Thanks for the reply Pturmel Can you explain bit more on the web search? AS400 web search? You meant sysa or sysb,etc.. I’m new to this AS400! ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [August 26, 2025, 11:27pm UTC](https://forum.inductiveautomation.com/t/as400-database-connection/22800/13 "2025-08-26T23:27:09Z")
I meant Google or StackExchange or something like that. AS400 is a bit niche--I have no experience with it (other than a chip design internship long, long ago 😐 ). ---
**Author:** ![uy\_huynh](https://avatars.discourse-cdn.com/v4/letter/u/54ee81/32.png) [@uy\_huynh](https://forum.inductiveautomation.com/u/uy_huynh)\ **Post date:** [August 28, 2025, 7:52am UTC](https://forum.inductiveautomation.com/t/as400-database-connection/22800/14 "2025-08-28T07:52:54Z")
deleted