https://support.industry.siemens.com/cs/document/109779336/connecting-a-s7-1200-plc-s7-1500-plc-to-a-sql-database-?dti=0&dl=en&lc=zh-WW
我是参考这个链接上的教程,用里面的例子,在SQLServer2019上创建一样的数据库和表,创建一样的用户名和密码,但是S7-1500连接SQLServer2019连不上。在SQLServer2019同一台电脑上开启TCP调试助手,但是用S7-1500去连接TCP调试就可以连接上。
以下是我测试的数据库,也是根据西门子库文档创建的,为方便大家测试,我贴出源文件代码和数据库文件,大家自行选择SQLFromPLC数据库文件.zip:
数据名称为SQLFromPLC,自己创建就行。
PLCDATA_1表的SQL语句如下:
USE [SQLFromPLC]
GO
/****** Object: Table [dbo].[PLCDATA_1] Script Date: 2022-12-28 02:07:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PLCDATA_1](
[IntegerValue1] [int] NULL,
[IntegerValue2] [int] NULL,
[IntegerValue3] [int] NULL
) ON [PRIMARY]
GO
PLCDATA_2表的SQL语句如下:
USE [SQLFromPLC]
GO
/****** Object: Table [dbo].[PLCDATA_2] Script Date: 2022-12-28 02:08:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PLCDATA_2](
[Amount] [int] NULL,
[Color] [nchar](30) NULL,
[Fruit] [nchar](50) NULL,
[Fresh] [bit] NULL,
[Country] [ntext] NULL,
[CountryCode] [nchar](5) NULL,
[City] [ntext] NULL,
[Taste] [nchar](20) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
PLCDATA_3表的SQL语句如下:
USE [SQLFromPLC]
GO
/****** Object: Table [dbo].[PLCDATA_3] Script Date: 2022-12-28 02:10:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PLCDATA_3](
[number] [int] NULL,
[occurance] [datetime] NULL
) ON [PRIMARY]
GO