Table disconnected in Live but in Ignition Design connected

Hi I have encountered this issue, in Project it has red disconnected db in table.

But in Ignition design it is connected.

Check in your project properties – you probably need to enable legacy queries.

We encountered the same problem and found two solutions in our environment.
Solution A: Change from SQL to a NamedQuery (my preference)
Solution B: Change the “Legacy Database Access” setting in:
      Project > Properties > Permissions

Hopefully one of those will work for you.

1 Like