Skip to Content

SiePortal

The integrated platform for your product selection, buying and support workflow - bringing together Industry Mall and Online Support.

SiePortalDeutsch

Search

Home
Support Support
{{(apiData.Support | filter:{'rank':1}:true)[0].title}} Support
- Menu temporary not available
- Menu temporary not available
- Menue temporary not available
- {{item.title}}

Products & Services
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Support Support
{{(apiData.Support | filter:{'rank':1}:true)[0].title}} Support
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
MySiePortal MySiePortal
{{(apiData.MySiePortal | filter:{'rank':1}:true)[0].title}} MySiePortal
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Cart ({{apiData.CartCount}})

Navigation

How to read from SQL Database with plc 1200 and TIA portal v16

Created by: mahsa.h at: 6/15/2020 12:05 PM (23 Replies)

Rating (6)

Thanks 3

Result pages:: |; 1 | 2 | 3; |

24 Entries

Entries per page: 10 | 20 | all

7/13/2020 4:30 AM	Rate (0)
kang_yudi Posts: 4 Rating: (1)	Hello Mahsa and All, Do you have a good progress to read from SQL database, I would like you to share if you or someone success in reading from database with SELECT command, Thanks
kang_yudi Posts: 4 Rating: (1)
Suggestion To thank Quote Answer

7/13/2020 7:04 AM	Rate (0)
mahsa.h Posts: 15 Rating: (1)	hello kang_yudi you can use this >> https://support.industry.siemens.com/cs/ww/en/view/109779336 and You probably won't have a problem for read from SQL
mahsa.h Posts: 15 Rating: (1)
Suggestion To thank Quote Answer

7/13/2020 11:44 AM	Rate (0)
kang_yudi Posts: 4 Rating: (1)	Helo, With that LSQL_microsoft library I only able to execute Insertinto command, as the topic is read from SQL database,it must use SELECT command. Did you successfully test the select command with that libray? I hope you share us to execute the select command Thanks
kang_yudi Posts: 4 Rating: (1)
Suggestion To thank Quote Answer

7/20/2020 11:24 AM	Rate (0)
aliang999 Posts: 3 Rating: (0)	Connect s7-1200 / S7-1500 to SQL database, can I read sql data?
aliang999 Posts: 3 Rating: (0)	Last edited by: aliang999 at: 07/20/2020 11:25:38
Suggestion To thank Quote Answer

7/20/2020 11:32 AM	Rate (0)
Kirschiaub08 Gold Member Joined: 4/25/2017 Last visit: 12/22/2025 Posts: 443 Rating: (71)	aliang999 Connect s7-1200 / S7-1500 to SQL database, can I read sql data? Yes you can, but it is not easy at the moment... The best way is to wait a few weeks. The support said that a update is in progress
	Best Regards, Kirschiaub08
Suggestion To thank Quote Answer

7/21/2020 8:57 PM	Rate (0)
fatemieh.m Posts: 31 Rating: (2)	you can write and update data in SQL but You can not read the data yet. I think we should wait for the library to be updated As Kirschiaub08 said
fatemieh.m Posts: 31 Rating: (2)
Suggestion To thank Quote Answer

9/17/2020 1:46 PM	Rate (0)
Gazza1981 Posts: 18 Rating: (1)	Hi Can you generate source blocks of the code from V16 application example please? I have V14 and can then import them, also have they sorted out the SELECT function?
Gazza1981 Posts: 18 Rating: (1)
Suggestion To thank Quote Answer

11/20/2020 3:16 PM	Rate (0)
SorLuc Posts: 1 Rating: (0)	Kirschiaub08 aliang999 Connect s7-1200 / S7-1500 to SQL database, can I read sql data? Yes you can, but it is not easy at the moment... The best way is to wait a few weeks. The support said that a update is in progress Any news on when they will release a update?
SorLuc Posts: 1 Rating: (0)
Suggestion To thank Quote Answer

11/23/2020 7:23 AM	Rate (1)
Kirschiaub08 Gold Member Joined: 4/25/2017 Last visit: 12/22/2025 Posts: 443 Rating: (71)	Hi, The update is online since friday (20. November) https://support.industry.siemens.com/cs/ww/en/view/109779336
	Best Regards, Kirschiaub08
Suggestion To thank Quote Answer
This contribution was helpful to 2 thankful Users fatemieh.m SorLuc

12/14/2020 2:32 PM	Rate (0)
fatemieh.m Posts: 31 Rating: (2)	Kirschiaub08 Hi, The update is online since friday (20. November) https://support.industry.siemens.com/cs/ww/en/view/109779336 Hi guys Someone managed to read data from SQL by PLC I downloaded the example, but unfortunately the received data is not fixed ...
fatemieh.m Posts: 31 Rating: (2)
Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Follow us on