Configuring an S7-1200/S7-1500 to communicate with Microsoft SQL Database using Tabular Data Stream 

Nice work!

I completely stuck there I don't know what else I can do

Yes, absolutely. This was just a mere example to prove that it works, what you send is up to you and you can even read data back!

I don't think there's any library available for S7-300 so you might be best off having an intermediate IPC that will talk to your S7-300 and then access the SQL server. Or move to a S7-1500 ;)

I'd suggest checking our other video that shows you how to set SQL Express from scratch: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-JuletfZOP-M.html Once you go through this I'd confirm that you can access your database using Server Management Studio. If this doesn't work, you won't be able to connect from your PLC either and it means that you have either not configured your Microsoft SQL database correctly or something like a firewall or your specific network topology is causing issues

Even better - it works with PLCSim Advanced V2 as FW V2.6 is perfectly fine. Just tested it just to be on the safe side ;) Fun fact? It didn't work! Why? Because I turned off my SQL server ... With the server on it works perfectly fine! Thanks for watching

Check the types folder in you project library - this message is indicating you have put one of the types (Lsql_Microsoft) in edit mode. Right click it and select “discard changes” to restore back to a released version.

I tested it for another viewer and works perfectly fine with PLCSim Advanced. If you open the block itself you can check what these codes mean, hopefully they'll point you in the right direction. Also, did you check whether you can connect to the database using something like the Management Studio?

@@AutomationStation In my PC, i am using SQL server 2014. in this video, you use SQL server 2017, can SQL server 2014 connect ?

I am also getting the same Error, 16#8602 & 16#80C5 using PLCSImAdvance 3.0 & Example project of Siemens.

Well I haven't tested with V3 but works perfectly fine with V2

I have the same error and still can´t figure out what is the problem

Not sure I get your question. If you talk about setting up SQL for WinCC I'd advise checking the WinCC manual, should have all the preconditions

I'm afraid this would only work with Microsoft SQL

When I use this example for S7-1200. An error occurs because FC Write to array is not supported. :(

@@lamsonlemai6516 ​ There are restriction on what S7-1200 can do which I mention in the video and are also listed in the documentation. For it to work with S7-1200 you need to comment few lines. Check 12:10

@@AutomationStation thank you very much.

Good question, I have not seen any performance values. I would suggest monitoring communication load of the PLC

There's a new version of the block available on the Siemens support site that supports SELECT, make sure to use this one and check the documentation for more info on how to do it

Not this way. For Azure check our MQTT video. Most cloud services like Azure or AWS use MQTT brokers so you need to have an MQTT client on your PLC to connect and send data to it. An alternative would be a hardware solution like the Cloudconnect 7 for example.

I dont think I do, sorry. You could try opening the v17 blocks in a trial version and copying them to v16 maybe

@@AutomationStation Hello friend, thanks for the reply, I got the v16 version

@@williamvidorette3797 Where did you find ?

@@mafrafree Hello friend, I got it from the person who posted another video, if you want, give me your email, I'll try to send it to you

Well I tested it with PLCSim Advanced V2 as FW V2.6 and it works perfectly fine so should also work with V3 FW V2.8

There's a new version of the block available on the Siemens support site that supports SELECT, make sure to use this one and check the documentation for more info on how to do it

Did you solve it?

@@sagamoreful no I never found a solution even on Siemens forums

Sorry I'm afraid I don't even have V15 installed and don't think the blocks support V15... You could get yourself a trial of V16 though and see if you can migrate the blocks to V15

Hello again! If what you're after is writing some dynamic data rather than predefined values to your SQL Database, that's pretty easy. If you look at the command at 11:26 you just need to build the command yourself by concatenating some strings. I'd make another function which would take my values as the input, and the table name as another input, concatenate these into an SQL command and then spit out the command and then I'd use this command as the actual parameter for my sqlCommand input. I was actually going to do it but didn't want to add extra blocks and confuse people ;)

@@AutomationStation Wait for your example, thank you.

I can read and write To salsy Microsoft SQL Server?

@@user-bh1on2xi3m Not sure what you mean by salsy, but it's possible to both read and write data from and to the SQL Server

@@AutomationStation Archiving received data (enableArchive, db, dbmax)----------->How to use?

Check the video description

@@AutomationStation got link but how I download Plz help

Can it work for tia 15

Sure! That's when you'd use the enableArchive, db and dbmax pins on the Lsql_Microsoft block.

@@AutomationStation but how do you read back in 1200 without the archive?

Hi Garry, yeah I'm afraid that's only possible with the S7-1500

@@AutomationStation you can actually do it. I managed to get it to read back in a 1200 . Also noticed the block isn't developed far enough for example it doesn't handle useful production db scenarios i.e. long insert or query commands. Had to modify that. Good concept but not good for memory space on plc or production ready for tracking parts etc.

@@garyharrison9146 Hi, we have a demo with the siemens "stock" example and we find the sqlcommand limited with string only. I can fit 6 analog measurements + column names with string [255]. Any tips how to change this before i hit siemens with support request? Requirement for us is max data length from plc - > sql to avoid manual splicing and time sync of the data to be send. Pdf Manual says 65kbyte send and receive limit so there should be a trick to use something else than string 255 for send. Also the datablocks have quite a lot of room for more than a string. Annoying siemens did not straight away give notes how to extend the example limits.

I'm afraid that SELECT might not be implemented in the block yet. Feel free to try to do it yourself though

did you implementet. or it was to hard?