WinCC Unified V16: Usage of ODBC for the default SQLight database

In this Video I show you can use a ODBC driver for the SQLight database. How to read and write values to it.

00:30 install a ODBC SQLight driver
SQLite driver

01:48 read process values
05:57 create database
07:52 write to our own database
10:45 read from our own database

SQLite browser

#DerHecht #WinCC #Unified #TIAPortal

[Martin-bqhd]

Great video. Don't forget to sanitize your input data. Sql injections is always a risk. Best regards

[ZEDketa]

With the voice is better... good job thanks a lot...

[prasathraja]

hello @DerHecht4.0 Im Trying to Follow the same procedure as u instructed, but still i cant able to Connect to SQlite Database.
Can you help with what are the other variables i need to check.

THANKS IN ADVANCE!!!

[mariiasyrykh]

Hello. Thank you for your video. Maybe do you know, it is possible to install a odbc driver on Unified Comfort Panel. Best Regards, Maria

[mohamedrabie]

Sir, at first thanks for your amazing videos it's really helped me, i need some help i am trying to write data on the SQLite database that is already created by the unified SCADA From kepserver but there is a message appeared this message is"the database can not opened" although i installed the ODBC Driver and also i can not browse the tables in it from kepserver, so may you help me to solve this issue?!
And thanks in advance

[joaomerlo]

Hello! Thanks for this video! I'm doing project, as you did in your video. Now, I'm need export database and convert to csv. I'm using SQLite. The idea would be to click on a button, with a code to download and convert to. Can you help me with this? Thanks for making videos about WinCC. It's helping me a lot!

[KbZazz]

Hi thanks for your videos they are very helpful and appreciated. I'm having trouble with this connection : in trace viewer I'm getting "Errors state : 0100". Do you know why this happens?

[benjaminmolina]

it's posible insert control DataGrid on WinCC Unified?