How to connect HMI to sql server

Question

How to connect HMI to sql server

Sahil1998 0

Hello, I am using Siemems HMI TP700 comfort and in its memory I have a table that stores value after reading barcode and i want to store that real time table into sql server..I tried every possible way to connect to sql server...but i cant..Can someone help regarding this issue...how to connect HMI to sql server?

Olaf Helper 47,581 Reputation points

2023-02-21T06:28:11.6133333+00:00

.I tried every possible way

And which ways was that? How do you intercat with that device. Sorry, really to less information, you have to provide much more details.
Sahil1998 0 Reputation points

2023-02-21T11:20:06.6+00:00

Like I am using sql server management studio to establish the communication... also referred this link https://support.industry.siemens.com/cs/document/61883659/how-do-you-access-an-sql-database-in-wincc-runtime-advanced-using-a-script-?dti=0&lc=en-DE
Seeya Xi-MSFT 16,671 Reputation points

2023-02-22T07:07:44.3933333+00:00

Hi @Sahil1998 ,

I have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let me know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Best regards,

Seeya

2 answers

Your answer

Olaf Helper 47,581 Reputation points

2023-02-21T06:28:11.6133333+00:00

.I tried every possible way

And which ways was that? How do you intercat with that device. Sorry, really to less information, you have to provide much more details.
Sahil1998 0 Reputation points

2023-02-21T11:20:06.6+00:00

Like I am using sql server management studio to establish the communication... also referred this link https://support.industry.siemens.com/cs/document/61883659/how-do-you-access-an-sql-database-in-wincc-runtime-advanced-using-a-script-?dti=0&lc=en-DE
Seeya Xi-MSFT 16,671 Reputation points

2023-02-22T07:07:44.3933333+00:00

Hi @Sahil1998 ,

I have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let me know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Best regards,

Seeya

Answer 1

Seeya Xi-MSFT 16,671

Hi @Sahil1998,

Please refer to this MS document: Connect to an ODBC Data Source (SQL Server Import and Export Wizard)

User's image

Best regards,

Seeya

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Answer 2

Olaf Helper 47,581

how to connect HMI to sql server?

That's more a Siemens HMI device related issue then a SQL Server one, so better ask in a Siemns forum.

Share via

How to connect HMI to sql server

2 answers

Your answer