SQL Bridge - Designer Works but Launched Project Does Not

Hi, I’m just starting out on a first project. But I can’t seem to get my SQL queries to work in a project. My tables and bar charts work in the designer fine. But once it’s launched to say a windowed view the table becomes red and doesn’t connect. Like so:

Everything works in the designer, it’s the thin clients that aren’t working. Any ideas?

Check your project’s security properties – you may need to allow legacy queries. (As opposed to Named Queries, the “correct” way to access the database from the client going forward.)

2 Likes

oh, wow that was a quick reply… .and yup that was it!! Under Client I turned on “Legacy Database Access” and it worked.

Thank you very much!

1 Like

You posted this last year. “Check your project’s security properties – you may need to allow legacy queries. (As opposed to Named Queries, the “correct” way to access the database from the client going forward.)”
I have the same issue. I have spend almost an hour looking, and I can’t find where this allow legacy queries checkbox is located. Can you give me the exact location of where to find it.
Thanks.

This setting is found under the project properties settings of the designer.

How to access the properties panel: https://docs.inductiveautomation.com/display/DOC79/Project+Properties#ProjectProperties-AccessingProjectProperties

Specific information on client permissions:
https://docs.inductiveautomation.com/display/DOC79/Project+Properties#ProjectProperties-ClientPermissions

Edit: corrected link to client permissions