Hi guys
This is the first time I am doing this but somewhere it seems I am doing something wrong.
I need to log a few tags on demand to an ODBC database but I cannot figure out how to do so.
I followed all the steps as written below
1. Create a new data log model
2. Added description, selected ODBC database and clicked the browse button for ODBC Data Source
3. I dont have a ready made data source so I clicked New, selected File Data Source Management (Machine Independent), Next and selected SQL Server.
4. Clicked Browse after that to save the database somewhere.
5. Clicking next and then finish I have to select the SQL Server to connect to in which I selected SQLEXPRESS which came in the drop down list.
6. Clicked next until the end without changing any options and then tested the connection, it said SUCCESSFUL
7. Closed the whole thing and then gave the path where I created the .dsn file to the ODBC Data Source Entry field.
8. Pressed Create Tables and it did so.
9. Did not specify anything in path, file management. Log Trigger was on Demand and I put in the tags I want to log.
10. Hit OK which closed the open window
11. Created a button and put in DataLogOn <name of the data log model>
12. Created a button and put in DataLogOff <name of the data log model>
Diagnostic messages say everything is ok, also shows a message saying it turns on and off but I do not see the data anywhere.
Any hints as to what am I doing wrong here!!
Thanks guys
This is the first time I am doing this but somewhere it seems I am doing something wrong.
I need to log a few tags on demand to an ODBC database but I cannot figure out how to do so.
I followed all the steps as written below
1. Create a new data log model
2. Added description, selected ODBC database and clicked the browse button for ODBC Data Source
3. I dont have a ready made data source so I clicked New, selected File Data Source Management (Machine Independent), Next and selected SQL Server.
4. Clicked Browse after that to save the database somewhere.
5. Clicking next and then finish I have to select the SQL Server to connect to in which I selected SQLEXPRESS which came in the drop down list.
6. Clicked next until the end without changing any options and then tested the connection, it said SUCCESSFUL
7. Closed the whole thing and then gave the path where I created the .dsn file to the ODBC Data Source Entry field.
8. Pressed Create Tables and it did so.
9. Did not specify anything in path, file management. Log Trigger was on Demand and I put in the tags I want to log.
10. Hit OK which closed the open window
11. Created a button and put in DataLogOn <name of the data log model>
12. Created a button and put in DataLogOff <name of the data log model>
Diagnostic messages say everything is ok, also shows a message saying it turns on and off but I do not see the data anywhere.
Any hints as to what am I doing wrong here!!
Thanks guys