cassidy387
Member
I've tried following "Wonderware InTouch HMI Supplementary Components Guide" but the value from sql not appear on intouch runtime screen.
I connect MS SQL server in SQL authentication.
action script
resultcode = SQLConnect(ConnectionID1, "Provider=SQLOLEDB;UID=tha;PWD=12;Initial Catalog=WSP;Data Source=WIN-L5BCJAA06OD;");
resultcode = SQLSelect(ConnectionID1, "Table1","Table1","","");
resultcode = SQLFirst(ConnectionID1);
"resultcode" tag name type is Memory integer.
"ConnectionID1" tag name type is Memory integer.
help me please, I dont know what to do.
I connect MS SQL server in SQL authentication.
action script
resultcode = SQLConnect(ConnectionID1, "Provider=SQLOLEDB;UID=tha;PWD=12;Initial Catalog=WSP;Data Source=WIN-L5BCJAA06OD;");
resultcode = SQLSelect(ConnectionID1, "Table1","Table1","","");
resultcode = SQLFirst(ConnectionID1);
"resultcode" tag name type is Memory integer.
"ConnectionID1" tag name type is Memory integer.
help me please, I dont know what to do.
Last edited: