7/5/2020 4:53 PM | |
Posts: 1 Rating: (0) |
Hello, I also try this example, but I am not able to run function "LSql_Microsoft" without error. First I set input enable and then executeSqlCommand, but the error output is always fast set TRUE with status 16#8605 Via Log file viewer for SQL server is shown: Message Login succeeded for user 'plc'. Connection made using SQL Server authentication. [CLIENT: 192.168.0.3] So data from PLC goes to SQL. Can somebody help me? I use: ------------------------------------------------------------------------------------------ |
Last edited by: Jen_Moderator at: 07/06/2020 09:58:30New subject after splitting |
|
7/29/2020 10:54 AM | |
Joined: 3/10/2019 Last visit: 4/13/2022 Posts: 4 Rating: (0) |
Sorry, I don't think I got it. What do you mean by project? Prokhorov Vadim |
7/29/2020 11:21 AM | |
Joined: 4/25/2017 Last visit: 9/24/2024 Posts: 430 Rating: (66) |
Are you using from the download link Connecting an S7-1200 / S7-1500 to an SQL Database |
Best Regards, |
|
7/29/2020 12:55 PM | |||
Joined: 3/10/2019 Last visit: 4/13/2022 Posts: 4 Rating: (0) |
Thank you for your answers! I've tried both of them and result is the same.
According to the error description you attached above what exactly should I fix? Prokhorov Vadim |
||
1/20/2021 6:24 AM | |
Joined: 9/2/2012 Last visit: 8/15/2024 Posts: 711 Rating: (30) |
Hello, I was also getting same error. So i have modified the Receive area part in the logic as attached. i tried 2 way. 1. with same data type, but used "data.bytes" specifically at receive area. 2. Create dummy DB and used as receive area. please see attachment. it solved my error. note- not sure is there problem with this modification. Attachment1200 SQL.pdf (624 Downloads) |
|
|
This contribution was helpful to3 thankful Users |
4/7/2021 3:00 PM | |
Joined: 3/8/2019 Last visit: 1/12/2024 Posts: 1 Rating: (0) |
following on from your suggestion, i tried that and it worked well, so I then went back and changed the PLC data type 'typeUseCaseSpecificData' the bytes array from 863 or whatever to 1000, from this i was able to then change back the line in LSql to
, and all works well with out the need for the extra db. |
Follow us on