# Database Connection in App

**URL:** <https://forum.inductiveautomation.com/t/database-connection-in-app/26842>\
**Category:** Ignition\
**Tags:** database\
**Created:** [July 24, 2019, 5:35pm UTC](https://forum.inductiveautomation.com/t/database-connection-in-app/26842 "2019-07-24T17:35:05Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![tanner\_j\_poulton](https://avatars.discourse-cdn.com/v4/letter/t/8baadc/32.png) [@tanner\_j\_poulton](https://forum.inductiveautomation.com/u/tanner_j_poulton)\
**Post date:** [July 24, 2019, 5:35pm UTC](https://forum.inductiveautomation.com/t/database-connection-in-app/26842/1 "2019-07-24T17:35:05Z")

</div>

Hi,

I have successfully linked my gateway server to a sql database and when I use SQL queries in Ignition Designer, I am able to read values as shown in the first image.

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

Unfortunately, when I open the app on its own, it seems that those same SQL queries no longer run properly.

 ![error](https://us1.discourse-cdn.com/inductiveautomation/original/2X/8/8adc459a2733af85ee4d35d2140bfcd239fefd87.png)

Any help or suggestions would be appreciated!

---

<div class="post-metadata">

**Author:** ![jpark](https://avatars.discourse-cdn.com/v4/letter/j/a88e57/32.png) [@jpark](https://forum.inductiveautomation.com/u/jpark)\
**Post date:** [July 24, 2019, 5:38pm UTC](https://forum.inductiveautomation.com/t/database-connection-in-app/26842/2 "2019-07-24T17:38:23Z")

</div>

In the project properties check the Legacy Database Access under Vision \> Permissions.  
Or switch to named queries.

---

<div class="post-metadata">

**Author:** ![tanner\_j\_poulton](https://avatars.discourse-cdn.com/v4/letter/t/8baadc/32.png) [@tanner\_j\_poulton](https://forum.inductiveautomation.com/u/tanner_j_poulton)\
**Post date:** [July 24, 2019, 5:45pm UTC](https://forum.inductiveautomation.com/t/database-connection-in-app/26842/3 "2019-07-24T17:45:22Z")

</div>

Fantastic! Thanks for the quick reply.
