12/30/2020 12:01 PM | |
Joined: 4/9/2020 Last visit: 8/19/2023 Posts: 11 Rating: (0) |
Since yesterday, I've tried to connect the database via TCP/IP (TDS) using this Siemens application: https://support.industry.siemens.com/cs/document/109779336/connecting-an-s7-1200-s7-1500-to-an-sql-database-?dti=0&lc=en-WW and try to download one easy record from database MS SQL to my PLC. I succeeded in indirect connection but now I don't know how to handle the next problem. I see that the database can't transfer me any data. I have status error 8088 which still occurring when PLC tries to receive data. I think it happens before sending SQL command and before executing it. Details about occuring errors: ERROR 8605 (description: Error when calling TRCV) STAUS ERROR 8088 (description: If you have specified the length of the data to be received (DATA parameter of FB 64 "TRCV") to be less than the length of the sent data, FB 64 will not copy any data into the receiver range but instead will supply the following error information: ERROR=1, STATUS=W#16#8088.) statFBErrorState 7 (description: it's the section of the function where stopped working) I added my project in the attachment. I'd be immensely grateful for any help or advice. Attachmentpolaczenie_z_baza.zip (312 Downloads) |
Last edited by: zyzio at: 12/30/2020 12:01:49 |
|
1/20/2021 6:25 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 (491 Downloads) |
|
|
This contribution was helpful to1 thankful Users |
Follow us on