# DB2 Connection Error

**URL:** <https://forum.inductiveautomation.com/t/db2-connection-error/24541>\
**Category:** Ignition\
**Created:** [May 1, 2019, 6:14am UTC](https://forum.inductiveautomation.com/t/db2-connection-error/24541 "2019-05-01T06:14:05Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![1Guillermo](https://avatars.discourse-cdn.com/v4/letter/1/ecae2f/32.png) [@1Guillermo](https://forum.inductiveautomation.com/u/1Guillermo)\
**Post date:** [May 1, 2019, 6:14am UTC](https://forum.inductiveautomation.com/t/db2-connection-error/24541/1 "2019-05-01T06:14:05Z")

</div>

I’m trying to create a connection to db2 but I get the following error  
 ![error%201](https://us1.discourse-cdn.com/inductiveautomation/original/2X/6/6cc46fefcf1172a785c025620713c4c913b3c8c1.png)

I tried with an as400 connection but it also fails.  
[https://support.inductiveautomation.com/index.php?/Knowledgebase/Article/View/120/0/connecting-to-ibm-as400-iseries-database](https://support.inductiveautomation.com/index.php?/Knowledgebase/Article/View/120/0/connecting-to-ibm-as400-iseries-database)  
 ![error%202](https://us1.discourse-cdn.com/inductiveautomation/original/2X/4/444eff10ecb09bf2858cc94783f39abf053e41cb.png)

Does anyone have an idea why it fails?

---

<div class="post-metadata">

**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:** [May 1, 2019, 1:14pm UTC](https://forum.inductiveautomation.com/t/db2-connection-error/24541/2 "2019-05-01T13:14:00Z")

</div>

“Obtain a licensed copy” seems pretty clear to me. You probably need to talk to IBM sales.

---

<div class="post-metadata">

**Author:** ![1Guillermo](https://avatars.discourse-cdn.com/v4/letter/1/ecae2f/32.png) [@1Guillermo](https://forum.inductiveautomation.com/u/1Guillermo)\
**Post date:** [May 1, 2019, 7:58pm UTC](https://forum.inductiveautomation.com/t/db2-connection-error/24541/3 "2019-05-01T19:58:38Z")

</div>

I also thought that, I have a valid licence and I can connect to DB using C#.Net, also using a DSN Driver  
. ![error%203](https://us1.discourse-cdn.com/inductiveautomation/original/2X/7/7a1b683e7db507d094d9632d4f6a6c7bcc13a545.png)

The problem is IGNITION

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [May 1, 2019, 8:02pm UTC](https://forum.inductiveautomation.com/t/db2-connection-error/24541/4 "2019-05-01T20:02:32Z")

</div>

ODBC != JDBC.

> The **JDBC** driver in use is not licensed for connectivity to QDB2 databases.

You need an additional .jar file for the DB2 JDBC driver.

---

<div class="post-metadata">

**Author:** ![1Guillermo](https://avatars.discourse-cdn.com/v4/letter/1/ecae2f/32.png) [@1Guillermo](https://forum.inductiveautomation.com/u/1Guillermo)\
**Post date:** [May 1, 2019, 8:10pm UTC](https://forum.inductiveautomation.com/t/db2-connection-error/24541/5 "2019-05-01T20:10:24Z")

</div>

I’m really lost, What jar file I need?

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [May 1, 2019, 8:13pm UTC](https://forum.inductiveautomation.com/t/db2-connection-error/24541/6 "2019-05-01T20:13:59Z")

</div>

According to the error message, `db2jcc_license_cisuz.jar`; which [you should be able to find somewhere in your software distribution](https://stackoverflow.com/a/48090412), apparently.
