Database Connection in App

tanner_j_poulton · July 24, 2019, 5:35pm

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

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

Any help or suggestions would be appreciated!

jpark · July 24, 2019, 5:38pm

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

tanner_j_poulton · July 24, 2019, 5:45pm

Fantastic! Thanks for the quick reply.