# Writing data to AS400 with the JDBC-ODBC driver

**URL:** <https://forum.inductiveautomation.com/t/writing-data-to-as400-with-the-jdbc-odbc-driver/2028>\
**Category:** Ignition\
**Created:** [July 13, 2010, 4:21am UTC](https://forum.inductiveautomation.com/t/writing-data-to-as400-with-the-jdbc-odbc-driver/2028 "2010-07-13T04:21:15Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![HertwichChristof](https://avatars.discourse-cdn.com/v4/letter/h/87869e/32.png) [@HertwichChristof](https://forum.inductiveautomation.com/u/HertwichChristof)\
**Post date:** [July 13, 2010, 4:21am UTC](https://forum.inductiveautomation.com/t/writing-data-to-as400-with-the-jdbc-odbc-driver/2028/1 "2010-07-13T04:21:15Z")

</div>

Hi!

I have a Problem writing data to an AS400 Database via the JDBC-ODBC driver.

I already have a valid connection to the Database (which was also a hard work).  
So it look likes the DSN works.  
And I also can see the existing tables at the Database.

When i launch the designer the connection to the table seems alright.

But when I add an OPC Tag (via FactoryTalk Gateway from a ControlLogix) i get the Error “Unable to start group. ResultSet is closed”.

If i try to do an query to the table like “Select \* from Table”, i get the following error message:  
[DB2 UDB]SQL0104-Token 1000 was not valid. Valid tokens: FOR WITH FETCH ORDER UNION EXECPT OPTIMIZE

Has someone a clue what could be wrong?

My software versions:  
Ignition: 7.1.2  
SQL Bridge: 5.1.2  
Java: 1.6.20

Thx for any help

Christof

---

<div class="post-metadata">

**Author:** ![nathan](https://avatars.discourse-cdn.com/v4/letter/n/c5a1d2/32.png) [@nathan](https://forum.inductiveautomation.com/u/nathan)\
**Post date:** [July 13, 2010, 8:47am UTC](https://forum.inductiveautomation.com/t/writing-data-to-as400-with-the-jdbc-odbc-driver/2028/2 "2010-07-13T08:47:06Z")

</div>

Have you considered the following:

1. Use a direct JDBC driver to communicate with your AS400 database. The JDBC-ODBC connection type is primarily recommended for Microsoft Access and probably not the best idea if you can avoid it. I found the following links with a quick Google search.

[novell.com/coolsolutions/tip/15172.html](http://www.novell.com/coolsolutions/tip/15172.html)  
[jt400.sourceforge.net/](http://jt400.sourceforge.net/)

1. Connect to your ControlLogix PLC directly in Ignition instead of via FactoryTalk.

---

<div class="post-metadata">

**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:** [July 15, 2010, 1:49pm UTC](https://forum.inductiveautomation.com/t/writing-data-to-as400-with-the-jdbc-odbc-driver/2028/3 "2010-07-15T13:49:52Z")

</div>

> [@nathan](#):
>
> Use a direct JDBC driver to communicate with your AS400 database.