I seem to be getting a recurring error with indusoft web studio. My values from my meters seem to have stopped recording to the DB and this is the db messages I get on my IWS log output:
Database: Error: Fail trying to connect to Studio Database Gateway. If you are running the gateway on a remote computer, make sure that the gateway is running on the same port as you configured in your project. [Connection String: 'Provider=SQLOLEDB.1; Integrated Security=SSPI; Initial Catalog=ABPBandonMIS; Data Source=ABP-BAN-SD-01', Table: 'Runtime_Values_Water']
Database: Error: Error to add new register[CMD_ADD] [Connection String: 'Provider=SQLOLEDB.1; Integrated Security=SSPI; Initial Catalog=ABPBandonMIS; Data Source=ABP-BAN-SD-01', Table: 'Runtime_Values_Water']
Anybody got any ideas on what is going wrong here or what I can do to fix this?
There is 2 instances running probaly, check your code to always open and close a DBCursor or Instance. Check your DB Dashboard to see if your user is connected.
Try to use the returno code for Indusoft DB functions and process the errors codes.
Error List