3/25/2025 2:11 PM | |
Joined: 1/31/2025 Last visit: 3/27/2025 Posts: 3 Rating:
|
Hi!! My computer is connected to a physical PLC S7-1200 (model 1214C DC-DC-RLY), which I configured in the project with the LSql_Microsoft function (block to send data to the MSSQL Server) to send three non-constant variables over time to SQL. It should be noted that I used a TCP connection on a local server on my machine via Ethernet. However, when I try to send a SQL command (enableSql = TRUE), it recognizes the output "Busy" = TRUE, and output ERROR = FALSE, but it does not recognize the data transmission (in the image of the attachment file it's shown the LSql_Microsoft code where the TCON does not transmit data but neither detects error). That is why I would like to consult what is the error in the SQL configuration or in the parameters of ConnectionSettings (SqlConfig block) or some other detail to consider, so that it can send the data to the SQL Server. Thank you for the attention AttachmentSQL CONNECTION ERROR.zip (182 Downloads) |
Last edited by: jose_paredes145 at: 03/25/2025 14:12:37 |
|
3/27/2025 1:55 PM | |
Joined: 8/3/2009 Last visit: 9/12/2025 Posts: 16409 Rating:
|
Hello jose_paredes145 Check out the Information in this application example: https://support.industry.siemens.com/cs/de/en/view/109779336 But I think your PLC Firmware of your S7-1200 has to be V4.4 or newer Bye Murof |
Last edited by: Murof at: 03/27/2025 13:56:11Last edited by: Murof at: 03/27/2025 13:57:52If this Information really helps, you could use the Rate function |
|
Follow us on