How to connect data between TIA Portal V17 with Ms SQL Server by using VB script

[@usamashaikh7130]

Really the Tutorial is Great, but i faced the same problem what happen at 1:29:00 time in video and i cannot see any value in SQL table. Can you advise what should i check?

[@generaltechnologyknowledge5165]

Please check the trigger option because it will follow option that we choose such as screen change...
And then you can try to test again.
Thanks

[@ChandanShrivastavaa]

For me also not working

[@Brian_Banda.]

Thank you so so much. Please upload more videos including vb scripts

[@generaltechnologyknowledge5165]

Ok sir

[@ganeshkhanderay2971]

absolutely, helpful thanks for video can you make tutorial for how to read data from SQL and write it into particular tags.

[@raghavendra1989]

Very usefull sir ...but Please make vedio for s7300 plc simatic manager software with microsoft sql data base as same as like this vedio ....please do neefull sir it will be helpfull ...

[@saedalhabbashi2790]

What did you make that you were able to show data on SQL table?
The trigger is still user change???

[@SKCLAutomation]

Excellent.

[@generaltechnologyknowledge5165]

Thanks

[@mohsinalishaikh1792]

Amazing topic covered. keep up the good work, also please if you can communicate TIA portal Ignition SCADA and SQL database

[@generaltechnologyknowledge5165]

Yes sir

[@PrashantThapa-rz5cd]

thanks and all the best for future

[@generaltechnologyknowledge5165]

Thanks you sir

[@b00cian]

Hi,, ofc i have a problem. Don't see any values , i trigger Script by other PushButton which I created inside HMI. Can You help somehow?

[@thanhsono3910]

Thanks for your video, it really helpful

[@patsagornpiwaeim159]

Thank you So Much. Please Help me How to add Date Time Stamp into SQL Server

[@generaltechnologyknowledge5165]

Dear sir,
Normally time stamp automatic created when SQL logged
Thanks

[@tarekmohsen7572]

Thank you very much my brother.

[@generaltechnologyknowledge5165]

You are very welcome sir

[@denizulaskaplanoglu1159]

Very nice work. Siemens has released a new library for communicating with sql. lsql v3.0. Are you going to make an example for this library?

[@generaltechnologyknowledge5165]

Thanks you sir

[@gawor89]

Can you tell my why i can't save to MS SQL variable DTL and Srtring ? In SQL i have used DataTime Variable and nvchar variable and data don't save.

[@generaltechnologyknowledge5165]

Please review script and try again sir
Thanks

[@gawor89]

​@@generaltechnologyknowledge5165 I try on different ways. I think that i have bad variable type in sql. When save two or three TIA variable Intiger to SQL variable Intiger all is ok.
TIA variable DTL to SQL variable Datatime and TIA variable String to SQL variable Nvchar is ok ?
Otherwise very good video :)

[@AmitGupta-su5gp]

I have s-7 -1200 system and my ms excel data stops after week time ? Can u Guide

[@sanaullahbhatti8593]

Could you please write script to add date and time as the first column in the table ?

[@generaltechnologyknowledge5165]

Dear sir,
That OK

[@joshuacvzn]

@@generaltechnologyknowledge5165 Is the script ready to add the date-time?

[@altangozel263]

How can we solve the problem what happen at 1:29:00 it is really important for me can u help please