Skip to Content

Register Login

Industry Online Support

Technical Forum

Navigation

WinCC Communication with SQL Server

Created by: JustinT at: 3/8/2007 3:41 AM (8 Replies)

Rating (0)

Thanks 0

9 Entries

3/8/2007 3:41 AM	Rate (0)
JustinT Posts: 3 Rating: (0)	Hi, Is it possible for WinCC V6.0 to read and display data from a SQL Server database residing on another server? The other server does not have WinCC or OPC Server installed. If so, how is it done? Thanks. Justin
JustinT Posts: 3 Rating: (0)	Last edited by: JustinT at: 08.03.2007 04:44
Suggestion To thank Quote Answer

3/8/2007 8:43 AM	Rate (0)
Nemo Posts: 3149 Rating: (171)	HI I think this issue has already been discussen /tf/WW/en/Posts/5901 or search for "WinCC connectivity pack" or WinCC data bridge http://support.automation.siemens.com/WW/view/en/22578952 nemo
Nemo Posts: 3149 Rating: (171)
Suggestion To thank Quote Answer

3/8/2007 9:16 AM	Rate (0)
JustinT Posts: 3 Rating: (0)	Thanks, Nemo. My question is a bit different. I want to display some internaltag values in WinCC. The values need to be updated regularly from a SQL Server database running on a remote server. The remote server has no OPC server installed. Is there any way to do the above without WinCC Industrial Data Bridge? Am I able to use VBS to connect directly to the remote database and update the tag periodically? Thanks.
JustinT Posts: 3 Rating: (0)
Suggestion To thank Quote Answer

3/8/2007 10:14 AM	Rate (0)
Ikkezelf Posts: 1084 Rating: (72)	Hi, Sorry to disagree with you there. Nemo is right this is already discussed. It does not matter if you want to read data out of a sql server on its own or a sql server that belongs to wincc (technical that is). Use the search functionality and you will find some example code on how to achieve this. with regards, Ikkezelf
Ikkezelf Posts: 1084 Rating: (72)
Suggestion To thank Quote Answer

3/21/2007 12:37 PM	Rate (0)
sash Posts: 4 Rating: (0)	If you want only to read some values from SQL this it's possible – you must read via ODBC (I read data from M$ ACCESS via ODBC). Communication and Query's are write in scripts (C or VB).
sash Posts: 4 Rating: (0)
Suggestion To thank Quote Answer

4/15/2007 5:29 AM	Rate (0)
elme2 Posts: 1 Rating: (0)	Hi everybody. I want to do something like this, but the difference is that i want to read data from SQL Server but from a table made by me, so it is not a WinCC table nor user archive. I found someone who uses in C-scipts the commands DBConnect and DBExecuteDirect_hdsn (they where provided in WinCC libraries) for making the connections and writing. I need to read using a query, but i dont know howif i can use theDBExecuteDirect_hdsn to send the query, what kind of object do i need to store the results of the query and how to initialize them. Hope you could give me some advise Thanks for your help greetings
elme2 Posts: 1 Rating: (0)
Suggestion To thank Quote Answer

4/17/2007 1:50 PM	Rate (0)
Salma Gold Member Joined: 9/27/2005 Last visit: 11/27/2007 Posts: 1398 Rating: (150)	There are examples on my site at http://www.wincc.net Salma

Suggestion To thank Quote Answer

1/11/2008 4:46 AM	Rate (0)
Bheja Posts: 18 Rating: (0)	Hi, Please provide a seperatelink to download all WinCC related sample projects. Since link given is not accessible. Bheja
Bheja Posts: 18 Rating: (0)
Suggestion To thank Quote Answer

1/11/2008 4:57 PM	Rate (0)
CS Moderator Moderator Joined: 9/1/2005 Last visit: 8/24/2023 Posts: 4099 Rating: (193)	Hello Bheja, I've tested it. I'm able to open the salmas webpage. Maybe there was a temorary problem? Or you are not allowed to visit external pages??? Best regards CS Moderator
	My Forum is the place to personalize your profile, track your topics, and maintain content that interests you. Best regards CS Moderator
Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Follow us on