Hello,

I am using application example (Connecting an S7-1200  to an SQL Database) to send data from S71200 to SQL Database. I can see no errors in the PLC , the connection is fine. The only problem is that I can't receive the data in the SQL when I execute. I am trying to sent values ( 7,8,9 ) from the plc but nothing update when I try to execute it. Please find attached what is the plc showing , I don't know if this something to do with not receiving the data in SQL. Do you guys have any idea why this is happening as the connection is fine and no errors when toggling the input in the plc.

Thanks in Advance

------------------------------------------------------------------------------------------
Split from PLC-S1200 and SQL.

Is the posted image the string data built to send, SQL commands sent, SQL responses received, SQL commands replied back as an acknowledge?  What exactly are the ???'s referencing?

Are they pointing to the data buffer sent to the SQL server, or the data being copied to the data buffer ready to send to the SQL server?

More info is needed.

AutoGen_2742142

Hello,

I am using application example (Connecting an S7-1200  to an SQL Database) to send data from S71200 to SQL Database. I can see no errors in the PLC , the connection is fine. The only problem is that I can't receive the data in the SQL when I execute. I am trying to sent values ( 7,8,9 ) from the plc but nothing update when I try to execute it. Please find attached what is the plc showing , I don't know if this something to do with not receiving the data in SQL. Do you guys have any idea why this is happening as the connection is fine and no errors when toggling the input in the plc.

Thanks in Advance

Hello,

Thanks for your reply.

I've been able to receive data from SQL sent to the PLC. But , I can't sent data from PLC ( Still Trying to execute in SQL but nothing happening ).

May I know from where the data are sent in the PLC?

Thanks

Hello AutoGen_2742142

do you use the example from

https://support.industry.siemens.com/cs/de/en/view/109779336

Bye Murof