question

Mathias-4160 avatar image
0 Votes"
Mathias-4160 asked Criszhan-msft answered

Data receive from SQL to Siemens S7-1200

Hi
I am doing some data logging from a Siemens PLC.
I have got communications up and running, and can send data from the PLC to the Sql database.

My problem is that I can not be allowed to receive data from the Sql database. The Siemens manual says that using "Wireshark" and the TDS protocol I have to find the date that will be sent to the PLC, but I just can not find anything called TDS in "Wireshark".

Does anyone have an idea of ​​what the problem might be?

![87455-image.png][1]


sql-server-general
image.png (64.7 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
1 Vote"
ErlandSommarskog answered

I think you are better off asking in a forum devoted to Siemens PLC.

TDS is the protocol that is used with communication with SQL Server, to and from. Trying to get data from SQL Server by looking at the wire from Wireshark is quite advanced. And time-consuming.

I must say that the instruction above makes very little sense to me. I'm wondering if this is a subtle way to say "Don't do that!".

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Criszhan-msft avatar image
0 Votes"
Criszhan-msft answered

Hi @Mathias-4160,

I also think you should post this question to the Siemens forum, or a forum that set topic/zone for Siemens PLC. The tag(sql-server-general) indicates that this is a forum focused on SQL Server technical issues.

Please see if this similar case helps. (The forum may be suitable)
https://stackoverflow.com/questions/62403650/connecting-an-plc-siemens-s7-1500-to-an-sql-server-database

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.