I’m using Factory Studio connect with SQL server for storing data from Factory studio into SQL Server.
The declaretation in Factory for TagHistorian Database as below picture
Everything worked well, Connetion between Factory and SQL was normal.
But in my project, I have an advanced requirement. I need to change ConnectionString of DB in factory during runtime operation.
I created a button with Code Behind to change ConnectionString of DBs. During Runtime operation, I could change ConnectionString of DBs, but Factory couldn’t connect to new Datasource. After that I paused and start again Dataset function in Startup Window.
The reason I have to change datasoure during runtime operation, when original Database of SQL Server is full Capacity, I need connect Factory studito to a new Database.
Please help me this case