AVEVA Edge SCADA | How to log Data in MSSQL Using VB Script | Full Tutorial

In this video, you will learn how to configure data logging from AVEVA Edge SCADA to a Microsoft SQL Server (MSSQL) database using a custom VB Script.

Whether you are working on industrial automation projects, building reporting systems, or trying to log process tags dynamically, this step-by-step tutorial covers everything from database connection strings to executing SQL queries inside AVEVA Edge.

📌 What You Will Learn in This Video:
00:00 - Introduction & Project Overview (AVEVA Edge to SQL)
00:10 - Creating the SQL Database & Data Logging Table
01:05 - Troubleshooting & Configuring ODBC Driver (64-bit setup)
02:15 - Setting up the "SQL Log" Interface Button in AVEVA Edge
02:44 - Pasting & Configuring the Data Logging VB Script
03:55 - Runtime Test 1: Finding connection errors (Null Data)
04:32 - Modifying the Script Connection String
07:10 - Fixing the Driver Issue: Setting up a 32-bit ODBC Data Source
08:20 - Updating the DSN in the VB Script
08:50 - Runtime Test 2: Successful Manual Database Data Logging
09:15 - Automating Log Entries using the Scheduler (Time Trigger)
10:15 - Final Script Adjustments & Verifying Continuous Data Logging

💻 VB Script Code Used in Video:
Comment Your Mail ID /Whatsaap No. i will provide the code.

🔔 Subscribe for more advanced industrial automation tutorials, PLC-SCADA tips, and scripting guides!
https://www.youtube.com/@AknitechSkillup/subscribe

💬 If you face any errors with the connection string or script execution, drop a comment below and I'll help you out!
👤 Connect With Me
Whatsapp: +91-7389942094
Email: kapil.29jha@gmail.com
--------------------------------------------------------------------------------------------------------------------------------------
🔎 Hashtags #AVEVAEdge #SCADA #SQLServer #VBScript #IndustrialAutomation #MSSQL #DataLogging

🎵 Music Credit:
Journey by Roa | https://roa-music.com
Music promoted by https://www.chosic.com/free-music/all/
Creative Commons CC BY 3.0
https://creativecommons.org/licenses/...

Видео AVEVA Edge SCADA | How to log Data in MSSQL Using VB Script | Full Tutorial канала Aknitech Skillup | PLC, SCADA & More