This is the first time i have tried to configure this sort of thing so please bare with me. I am attempting to configure Intouch to write data to an SQL Database Table. The Database and Intouch are on the same PC just now, so far i have:-
- Set-up a new SQL project called "OEE Database"
- Created a database called "FM02" in it
- Created a table called "FM02 OEE Data" inside FM02
- Created an ODBC connection to "OEE Database"
- Created a Bind List in Intouch with identical layout to "FM02 OEE Data" table
- Wrote a start-up script for SQL Connect :-
SQLConnect ( ConID_FM02_OEE, "DSN= OEE Database; DB= OEE Database" );
- Wrote a Shut-down script for SQL Disconnect :-
SQLDisconnect( ConID_FM02_OEE );
- Wrote an SQL Insert script :-
IF Test_SQL_Send == 1 THEN
SQLInsert( ConID_FM02_OEE, "dbo.FM02 OEE Data", "FM02 OEE Data" );
ENDIF;
Test_SQL_Send is just a test push button.
Checked that the SQl database is online.
I am probably missing something fundamental???
Any Ideas??
- Set-up a new SQL project called "OEE Database"
- Created a database called "FM02" in it
- Created a table called "FM02 OEE Data" inside FM02
- Created an ODBC connection to "OEE Database"
- Created a Bind List in Intouch with identical layout to "FM02 OEE Data" table
- Wrote a start-up script for SQL Connect :-
SQLConnect ( ConID_FM02_OEE, "DSN= OEE Database; DB= OEE Database" );
- Wrote a Shut-down script for SQL Disconnect :-
SQLDisconnect( ConID_FM02_OEE );
- Wrote an SQL Insert script :-
IF Test_SQL_Send == 1 THEN
SQLInsert( ConID_FM02_OEE, "dbo.FM02 OEE Data", "FM02 OEE Data" );
ENDIF;
Test_SQL_Send is just a test push button.
Checked that the SQl database is online.
I am probably missing something fundamental???
Any Ideas??