# Error listing tables for database connectio

**URL:** <https://forum.inductiveautomation.com/t/error-listing-tables-for-database-connectio/30867>\
**Category:** Ignition\
**Tags:** ignition79\
**Created:** [December 20, 2019, 3:55pm UTC](https://forum.inductiveautomation.com/t/error-listing-tables-for-database-connectio/30867 "2019-12-20T15:55:54Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![irwing-herrera-2b](https://avatars.discourse-cdn.com/v4/letter/i/cdc98d/32.png) [@irwing-herrera-2b](https://forum.inductiveautomation.com/u/irwing-herrera-2b)\
**Post date:** [December 20, 2019, 3:55pm UTC](https://forum.inductiveautomation.com/t/error-listing-tables-for-database-connectio/30867/1 "2019-12-20T15:55:54Z")

</div>

Hello everyone, I just did a default BD update in the overall project, and when I want to make a query I get the error that does not find any BDs, but in the designer if the queries work but published no longer.

Excuse my English and thank you for your help.

![Captura](https://us1.discourse-cdn.com/inductiveautomation/original/2X/4/4da58138d5d6d2a361d5bf002b9a731f4fbd8b47.png)

---

<div class="post-metadata">

**Author:** ![irwing-herrera-2b](https://avatars.discourse-cdn.com/v4/letter/i/cdc98d/32.png) [@irwing-herrera-2b](https://forum.inductiveautomation.com/u/irwing-herrera-2b)\
**Post date:** [December 20, 2019, 4:27pm UTC](https://forum.inductiveautomation.com/t/error-listing-tables-for-database-connectio/30867/2 "2019-12-20T16:27:18Z")

</div>

I was able to fix this, I just changed the default database to the correct one, but now the problem I have is that I can see data from the designer but when i move to a client I mark the following marks the following:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/4/42c9adaed618e4f792f00038006142f04487907c.png)

In the designer:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/f/fe3921abbdbe1898ebf9a26ac544ccbfdb930b4b.png)

Someone will know why this happens??

---

<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:** [December 20, 2019, 4:53pm UTC](https://forum.inductiveautomation.com/t/error-listing-tables-for-database-connectio/30867/3 "2019-12-20T16:53:08Z")

</div>

That’s probably due to missing legacy database access security permission. Look in your project properties to set that. You need it for database pens on the EasyChart.

---

<div class="post-metadata">

**Author:** ![irwing-herrera-2b](https://avatars.discourse-cdn.com/v4/letter/i/cdc98d/32.png) [@irwing-herrera-2b](https://forum.inductiveautomation.com/u/irwing-herrera-2b)\
**Post date:** [December 20, 2019, 5:16pm UTC](https://forum.inductiveautomation.com/t/error-listing-tables-for-database-connectio/30867/4 "2019-12-20T17:16:00Z")

</div>

thank you very much, if it was project permits.