WinCC 7.5 Insert Data into SQL

Insert data into SQL from WinCC 7.5 using ODBC connection.
in this video , I have already created a database and 6 columns to insert data from WinCC.
Must note -
1.Tag names defined in VB script are case sensitive.
2. Columns name in VB script must exist in SQL.
Download VB Script : stableautomatio...
#WinCC #SQL #insert #ODBC

[@user-xt4uy9mz1u]

Большое человеческое спасибо!

[@polucovekpolukomarac]

cool video. Thanks,
one thing i find hard to understand, in the script via the link I can see that the values you insert are with ' ' which means they are character type.
Is that correct? Are the values set as characters?

[@fastabiqhidayatulah]

Hi, why when I used script VALUES ('" & HMIRuntime.Tags("TAG_1") there is no value record to SQL. But when I used Values ("1234") it success to record. My data type value is Float.

[@pramodtakkar]

how are you saving time stamp in SQL database?I am able to save tag values .Didnt know how to save DateandTime along with data.

[@StableAutomation]

Set in SQL , so it will take timestamp of data being inserted

[@nestoraparra]

Can I question about timestamp, because the laboratory it’s ok, but timestamp i can’t enable

[@thienthanh7450]

thank you. i like video

[@prasadkrishna312]

Thanks bro

[@gl2802]

Hello, how i can make it into auto logging without click insert button?

[@StableAutomation]

Create event/ scheduled task

[@gl2802]

May i know how to create? I'm new in this topic and still learn

[@gl2802]

My friend, how to insert date and time in sql? When i look at your video, there is no script on VB

[@StableAutomation]

@@gl2802 that you need to set in SQL , to add timestamp when data are inserted.

[@farindn]

Interesting! Could you please give me more explanation of where I can get the DSN name?

[@StableAutomation]

You need to create manually. In ODBC connection.

[@farindn]

@@StableAutomation Thanks!

[@ajayvarghese3873]

How to save data automatically to database without insert button?

[@NasirKhan-fg6op]

Dear Ajay,
did you get answer of this question. I also wants to save the data without inser button. Please share the solution if you know.
Thanks in advance

[@mraine89]

could you inform what do i need license for this function?
please thanks for video

[@StableAutomation]

Wincc RT (runtime) license will be required.

[@mraine89]

@@StableAutomation Thank for the reply but nothing other else doesn't required?

[@whatacode]

How to check provider name

[@vorapobautomation9760]

Do you have C-Scripts for connect to SQL ?

[@StableAutomation]

Sorry , I have not used C for ODBC connection.
Any specific reason to use C script for this ?

[@vorapobautomation9760]

@@StableAutomation I just ask only but not important.
Can you give me the project ?

[@StableAutomation]

@@vorapobautomation9760 sure, will upload VB script and share shortly.

[@vorapobautomation9760]

@@StableAutomation Thank you.

[@StableAutomation]

Now you can download script from link given in video description..