# Easy Chart: Database pen error

**URL:** <https://forum.inductiveautomation.com/t/easy-chart-database-pen-error/62428>\
**Category:** Ignition\
**Tags:** ignition81, vision\
**Created:** [July 28, 2022, 8:05pm UTC](https://forum.inductiveautomation.com/t/easy-chart-database-pen-error/62428 "2022-07-28T20:05:04Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Carlos\_Villanueva\_He](https://avatars.discourse-cdn.com/v4/letter/c/7bcc69/32.png) [@Carlos\_Villanueva\_He](https://forum.inductiveautomation.com/u/Carlos_Villanueva_He)\
**Post date:** [July 28, 2022, 8:05pm UTC](https://forum.inductiveautomation.com/t/easy-chart-database-pen-error/62428/1 "2022-07-28T20:05:04Z")

</div>

Hi everyone,

I am trying to use the database pen functionality in Easy chart. I haven’t had much displaying the data when I publish the graph. I am only able to see it in the designer.

Here is what I’ve done:

- Created a simple table to prove that it was not my actual table. I used mysql.  

- Configure the database pen like seen here  

- last\_update is my time column. It’s already indexed. Here is the diagnostic.  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/d/7d5bc90f2ed21bbec35f54beda091c07181f1a1c.png)

- My graph populates in the designer but not when I launch the project.  

- Launched Project  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/c/0c3be907b691fe80c913609be8da92dbfe1580a3.png)

I believe everything is fine. I am really lost on this one.

Thank you in advance

---

<div class="post-metadata">

**Author:** ![Matthew.gaitan](https://avatars.discourse-cdn.com/v4/letter/m/59ef9b/32.png) [@Matthew.gaitan](https://forum.inductiveautomation.com/u/Matthew.gaitan)\
**Post date:** [July 28, 2022, 10:21pm UTC](https://forum.inductiveautomation.com/t/easy-chart-database-pen-error/62428/2 "2022-07-28T22:21:19Z")

</div>

You might need to enable "Legacy Database Access":

> [@Database Access from Client Issue](https://forum.inductiveautomation.com/t/database-access-from-client-issue/32396/6):
>
> If you’re using a pure SQL Query binding (as opposed to a Named Query binding), you need to enable permissions at the project level. In the Designer’s menu, select Project \> Project Properties. Now locate Vision \> Permissions in the table to the left. Enable “Legacy Database Access”. You can also specify roles if required while you are here. Click OK to apply your changes. Save the project.

Though I'm not 100% sure if it applies to the Easy Chart but it's worth a shot

---

<div class="post-metadata">

**Author:** ![Carlos\_Villanueva\_He](https://avatars.discourse-cdn.com/v4/letter/c/7bcc69/32.png) [@Carlos\_Villanueva\_He](https://forum.inductiveautomation.com/u/Carlos_Villanueva_He)\
**Post date:** [July 28, 2022, 10:26pm UTC](https://forum.inductiveautomation.com/t/easy-chart-database-pen-error/62428/3 "2022-07-28T22:26:21Z")

</div>

You got it 100% right.

Thanks for the reply! This was driving me crazy.

---

<div class="post-metadata">

**Author:** ![Matthew.gaitan](https://avatars.discourse-cdn.com/v4/letter/m/59ef9b/32.png) [@Matthew.gaitan](https://forum.inductiveautomation.com/u/Matthew.gaitan)\
**Post date:** [July 28, 2022, 10:27pm UTC](https://forum.inductiveautomation.com/t/easy-chart-database-pen-error/62428/4 "2022-07-28T22:27:11Z")

</div>

haha been there plenty of times! Glad that was the solution 🙂