I have a table, using an SQL Query binding from a newly created DB connection for a new project. Basic SELECT WHERE query, works fine.
I created a Tag, and want to use the same data source connection, but it is not in the drop down list, and if I type it in, I get an error stating it does not exist.
What's going on here? I've saved, updated...
Thanks
EDIT:
I even changed the Project default database to the newer one...
The Vision client is using the project settings which has the default database.
The Tag knows nothing about the client and therefore doesn't have a default database. You need to specify it.
If it's not in the dropdown list there is something wrong. Does it show up in the Named query datasource selector? If not,
- Check the gateway Config | DATABASES | Connections which should show "Valid" and that it's not faulted.
- Try a Designer restart.
Ok, just got in and did this:
- reset trial for developer
- restarted designer, again.
- checked the DB's, all connections are valid.
The same six DB connections are listed in the Tag Data source drop down. I don't know if this makes any difference, but four are MySQL and two are MSSQL (in the drop down). The only ones not showing up are MSSQL and one sample SQLite DB connection.
I also just added our standard Ignition SQL login (instead of the new one I created for this project) to that DB, with permissions, and no luck with that.
EDIT:
OK, so it turns out I need to create the DB connection on the main (aka licensed) server, which means that server is the tag "master source". Starting to make sense now!