Table disconnected in Live but in Ignition Design connected

Ignition
1

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

image.png1909Ă—653 5.42 KB

But in Ignition design it is connected.

image.png1328Ă—670 15.3 KB

2

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

3

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