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

SQL server connection with IOT2000

Created by: bergmanu at: 6/13/2018 4:50 PM (13 Replies)

Rating (3)

Thanks 9

Result pages:: |; 1 | 2; |

14 Entries

Entries per page: 10 | all

6/13/2018 4:50 PM	Rate (3)
bergmanu Platinum Member Joined: 4/28/2015 Last visit: 11/12/2024 Posts: 3345 Rating: (379)	Hi community, attached you cand find an application example how to install and create a SQL database (MariaDB) on the IOT2000 and how to connect to this database via node-red and C/C++. Note: You should have SQL knowledge if you want to use an own SQL database instead of the one in the example. How to manage SQL databases is not part of this document! Best regards! Attachment sql_client_server.pdf (3709 Downloads)
	Not working for IOT2050 support anymore from March 1st, 2024. I really enjoyed the time supporting you! :)
Suggestion To thank Quote Answer
This contribution was helpful to 7 thankful Users Jen_Moderator I.D. insanh davide_maffei crant Bharath Sharma gigiA

11/6/2018 1:27 PM	Rate (0)
insanh Posts: 10 Rating: (0)	Hi, i can't download your pdf file, because it protected with username & password, can u open your protect?, so i can access this file, big thanks...
insanh Posts: 10 Rating: (0)
Suggestion To thank Quote Answer

11/6/2018 1:34 PM	Rate (0)
bergmanu Platinum Member Joined: 4/28/2015 Last visit: 11/12/2024 Posts: 3345 Rating: (379)	Hi, you have to be logged in to the forum in order to download the PDF. Have you tried to download it after writing this post? Best regards!
	Not working for IOT2050 support anymore from March 1st, 2024. I really enjoyed the time supporting you! :)
Suggestion To thank Quote Answer

11/6/2018 1:40 PM	Rate (0)
insanh Posts: 10 Rating: (0)	i try it after reply your post, and doens't work, still username and password required, i dont know what to do...
insanh Posts: 10 Rating: (0)
Suggestion To thank Quote Answer

11/6/2018 2:29 PM	Rate (0)
bergmanu Platinum Member Joined: 4/28/2015 Last visit: 11/12/2024 Posts: 3345 Rating: (379)	Hi, have you tried to put in your username and password from the login you use for the forum usually? Best regards!
	Not working for IOT2050 support anymore from March 1st, 2024. I really enjoyed the time supporting you! :)
Suggestion To thank Quote Answer
This contribution was helpful to 1 thankful Users insanh

11/12/2018 2:26 PM	Rate (0)
insanh Posts: 10 Rating: (0)	bergmanu Hi, have you tried to put in your username and password from the login you use for the forum usually? Best regards! Hi Bergmanu,, thanks for your advice, and now my iot2040 work properly, used mariadb and apache. [snip] Best Regards, Insan (Indonesia)
insanh Posts: 10 Rating: (0)	Last edited by: Jen_Moderator at: 11/13/2018 9:49:52 AM Division of questions into separate topics.
Suggestion To thank Quote Answer

11/21/2018 5:04 AM	Rate (0)
Kas.Lewis Posts: 32 Rating: (1)	With the SQLite nodes no longer working is this thread no longer useful or can the database created here still somehow be used ? Thanks Kas
Kas.Lewis Posts: 32 Rating: (1)
Suggestion To thank Quote Answer

11/21/2018 8:03 AM	Rate (0)
bergmanu Platinum Member Joined: 4/28/2015 Last visit: 11/12/2024 Posts: 3345 Rating: (379)	Hi, the mysql node works. So you can use the example as described. Best regards!
	Not working for IOT2050 support anymore from March 1st, 2024. I really enjoyed the time supporting you! :)
Suggestion To thank Quote Answer

11/22/2018 4:41 AM	Rate (0)
Kas.Lewis Posts: 32 Rating: (1)	In the two threads listed below we had a LONG discussion about the SQLite nodes NOT working. You eventually decided that they could not be used with the IoT2020 due to hardware and software incompatibilities. Now you are saying that it still works. I'm confused and not sure how to proceed. Do the nodes work or not. Is this a stable platform or not. https://support.industry.siemens.com/tf/ww/en/thread/posts/201598/?page=0&pageSize=10 https://support.industry.siemens.com/tf/ww/en/thread/posts/184483/?page=0&pageSize=10
Kas.Lewis Posts: 32 Rating: (1)
Suggestion To thank Quote Answer

11/22/2018 7:11 AM	Rate (0)
bergmanu Platinum Member Joined: 4/28/2015 Last visit: 11/12/2024 Posts: 3345 Rating: (379)	Hi, there is a difference in the nodes mysql and sqlite. The two are not the same. Best regards!
	Not working for IOT2050 support anymore from March 1st, 2024. I really enjoyed the time supporting you! :)
Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Related topics by keywords:

SIMATIC IOT2000 Application

Follow us on