WinCC Unified Installing SQLite and first steps
Вставка
- Опубліковано 26 гру 2024
- Video tutorial on how to install SQLite and DB Browser for SQLite, create and configure a database, establish an ODBC connection and use a Wincc Unified project (TIA PORTAL) to manage interactions with the database:
1. Download and install SQLite from its official website.
2. Download and Install DB Browser from its official website to easily manage and interact with your SQLite databases.
3. Use DB Browser for SQLite to create a new database file.
4. Add a new table within this database and define its columns and data types. Configure the necessary user roles or permissions.
5. Download and install the SQLite ODBC driver from the website or other reliable source.
6. Configure the ODBC data source by linking it to your SQLite database through the Windows ODBC Data Source Manager.
7. Obtain a sample Wincc Unified (TIA PORTAL) project that includes SQL database operations such as Insert, Update and Delete.
Download SQLite:
www.sqlite.org...
sqlitebrowser....
www.ch-werner.d...
Download code:
github.com/Dno...