SQl-query from the non default database

Ignition
1

Hello,

Im trying to query a table located in a database that is not the default for the project, I don’t know how to set set it up, the example below is not working.

select * from [ServerName(IP)].[EVVThermoOperations].[dbo].[StoreRoomInventory]

2

If that’s in a Query Tag, you have to make sure the correct Datasource is selected under the query.
If the database you’re after is not available in the Datasource list it will need to be added under Configure->Connections on the Gateway web page.

Cheers,
David

3

Oh how did I miss that :laughing: , thanks !