Connecting an PLC Siemens S7-1500 to an SQL Server Database
The connection guide is here. I track the guide and do a lot of stuff.
The connection between PLC and SQL server is ok, I've login successfully to SQL.
I can insert to tables, update, and execute store procedures.
But when I run a select query I don't know how to retrieve data and read the values.
I use TIA PORTAL v16.
PLC: S7 1200 siemens
I have a simple table, I wanna simply read an integer, first with one row! then expand my work.
This is my table structure:
CREATE TABLE MyTable(
[id] [int] IDENTITY(1,1) NOT NULL,
[value] [int] NOT NULL,
)
) ON [PRIMARY]
and this is my select query:
SELECT [value]
FROM [dbo].[MyTable]
WHERE id = 12033
expected result:
20
UPDATE
I answered my own question, Please attention, Siemens recently (11/20/2020) published a document about Connecting an S7-* series to Microsoft SQL Server Database, directly. So the verfied anwser is the classic and normal way to connect PLC to SQL Server and the next answer is the latest native solution. Have fun
