The MsSQL library SL is a software library for CODESYS V3.5 applications that enables direct communication with Microsoft SQL Server versions 2005 through 2017 using the TDS protocol, allowing read and write operations for process data without middleware. It includes function blocks for database connection, ping testing, and queued query handling, and supports data type conversions for BOOL, DINT, REAL, STRING, and DATETIME. The library requires CODESYS Development System V3.5.8.10 and CODESYS Control V3.5.8.10, and runs on devices supporting the Network (NBS) library, including CODESYS Control WIN V3, Raspberry Pi, and WAGO PFC200. Licensing is activated via a CODESYS Runtime key.
The MsSQL library helps to read and store your data directly to Microsoft SQL Server without middleware (such as OPC). Without purchasing a license (just download) the library runs for two hours without functional limitations and shuts down automatically (demo).
| Codesys Group | |
|---|---|
| Product Category | Integrated Development Environment (IDE) |
| Product Number | 2112000003 |
| Product Name | MsSQL Library SL |