5/20/2011 9:18 AM | |
Posts: 1530 Rating: (59)
|
Hello samurai, you can try to use WinCC User Archive Option. For other possibilities you may have a look at an already discussed thread some time ago. Best regards Bizur |
Last edited by: Bizur at: 5/20/2011 9:20 AMLast edited by: Bizur at: 5/20/2011 9:20 AM |
|
5/20/2011 1:19 PM | |
Posts: 1530 Rating: (59)
|
Hello ABN, |
6/8/2011 10:38 AM | |
Posts: 291 Rating: (69) |
Hi, The following is an example (content in .bmo/ Global VBS Module) for writing Time, Process Value, String Value into one or more table of .mdb file. *** Don't need to prepare the Access MDB file & Tables inside. *** It works even if we don't hav MS Access installed. It depends on if the defined filename will vary or not! The code will check tha existence of the folder/ .mdf file / table, & create automatically it they don't exist. So ~ 1. just need to prepare the Tags in advance as match the pre-defined. sTagName = Array("Tag1", "Tag2", "Tag3", "Tag4", "Tag5", "Tag6", "Tag7", "Tag8", "Tag9", "Tag10", _ "Tag11", "Tag12", "Tag13", "Tag14", "Tag15", "Tag16", "Tag17", "Tag18", "Tag19", "StringTag") 2. call the main procedure "WinCC_AccessMDB()" upon a Tag's value-change or cyclically. Then you'll find the .mdb file created or updated under pre-defined D:\Report folder.
Regards,
Komi AttachmentWCC_CreateMDB.zip (229 Downloads) |
This contribution was helpful to1 thankful Users |
6/8/2011 4:37 PM | |
Posts: 26 Rating: (0) |
Another option use SQL 2005 server ( using ADO DB access), pls help me to explain more detail about this option ? |
6/8/2011 6:32 PM | |
Posts: 26 Rating: (0) |
I want a direct ADODB-accessing to Fields of Tables of SQL Server 2005. I need these fields :a tag for tank name, a tag for tank mass and Time stamp.
|
6/9/2011 6:20 AM | |
Posts: 291 Rating: (69) |
Hi Samurai, Before we go on discussion, Would you please contact & confirm with your local Siemens if it is legal to "take partial us of MS SQLServer 2005/WinCC Instance "freely by the way"? (There used to be related discussion here in this forum, but we still have no idea in conclusion.) Forgive me for saying so ~ please take the responsibility for your won usage of MS SQL Server 2005/WinCC Instance. Otherwise, please download SQL 2008 R2 Express for practice & usage!! http://www.microsoft.com/express/Database/ http://www.microsoft.com/express/Windows/ ,-------------------------------------------------------------------------------------------------------- ------------------------ Well~ now get back to our practice! You need to create your own Tank_DB with Tank_TBL & columns as shown in the attachment. Then I will give you the VB Scription for updating the data in WinCC. (The creation can be done by script, but then things will go more complicated. So~ please create your own DB & Table manually ;D Again, I beg you to confirm for the legal usage of SQL Server/ WinCC Instance in advance. I have no idea myself, so that I prefer the usage of SQLExpress version or .mdb / .xls datasource. Best regards, Komi P.S.: If you chose UserArchive, I believe you'll have yourself authorized for using UA. AttachmentCreate_TankDB.zip (207 Downloads) |
6/9/2011 8:07 AM | |
Joined: 10/3/2010 Last visit: 9/20/2024 Posts: 1562 Rating: (191) |
Does it work together with the SQL 2005 version installed by WinCC? |
Last edited by: SteBo at: 6/9/2011 1:35 PMB r g d s , |
|
Follow us on