I am working on an HMI right now that will need to populate IO fields with string information.

The catch is that this information is stored in a server room (networked to my stations) in a SQL database. I know that it is possible to create a text file with the specific data I need at the SQL server.

The concern I have is how I would go about bringing that text file to the HMI.

Have you guys seen this before? Do I have to target a specific directory and drop txt files in there? Or is it more of a situation where I write a script to go target the SQL database.

I am a little in over my head here.

Thanks in advance, any pointers are appreciated.

-Christopher

But may I ask why the tutorial states the following..
"NOTE: In general you CANNOT access SQL databases from a windows based CE panel."

Seems a little odd considering the title of the article is how to access a SQL database in WinCC via script.

Is this specifically only in the WinCC runtime environment?

That would be cool, but that only helps with testing purposes.

Hmm..

That is unfortunate news. I'm sure I can figure something out though by having our application software write to a txt, or rdb file (like you mentioned).

SQL is constantly being updated, so the preffered method would be to acces this database on command of the HMI.
This method will work to, I suppose it should be easy enough to copy, or even just query a simple text file on the server.

I would love to see the new TP series having this functinoality.

Anyways, thanks Tweety.

-Chris