Skip to Content

Register Login

Industry Online Support

Technical Forum

Navigation

Problem with C# and Wincc OLE DB driver

Created by: mara at: 6/8/2007 10:46 AM (3 Replies)

Rating (0)

Thanks 0

4 Entries

6/8/2007 10:46 AM	Rate (0)
mara Posts: 62 Rating: (2)	Hi all! I am trying to make C# application for exporting Alarm Message Archive. I had wrote application which connecting to WinCC database using Connectivity Pack v6.1 SP1. Here is sample code: [code]DataView pregled; DataColumn stupac; string sqlUpit; DataConn.DataSetHelper dsHelper; try { //DataConn.ConnectionString="Provider=WinCCOLEDBProvider.1;Catalog=" + DatabaseName + ";Data Source=" + ServerName + "\\WinCC" conn = new OleDbConnection(DataConn.ConnectionString); conn.Open(); causeData = new DataSet(); //this is SQL query - view is ALGVIEWRUS sqlUpit = "ALARMVIEW:SELECT * FROM " + "ALGVIEWRUS"; datadapter = new OleDbDataAdapter(sqlUpit, conn); //filling data adapter datadapter.Fill(causeData,"tablica"); //using DataGridView object to display data dataGridView1.DataSource = causeData.Tables[0]; conn.Close();[/code] 1. QUESTION Why when I use query like this "ALARMVIEW:SELECT DateTime FROM ALGVIEWRUS" I get error like in attachment(SelectError.jpg)? 2. QUESTION When I select all data in column DateTime I can see only date and time, but without seconds. Where is the problem? I am using WinCC v.6.0+SP4 and Connectivity Pack v6.1+SP1. Thank you for your help! Attachment WinCCExportError.zip (67 Downloads)
mara Posts: 62 Rating: (2)
Suggestion To thank Quote Answer

6/11/2007 5:18 PM	Rate (0)
Ikkezelf Posts: 1084 Rating: (72)	Hi, haven't used the connectivity pack myself, but cause the topic is still open I will give it a try... I notice that the ConectionString is placed in comment in your script. Is the connection string already set somewhere else? For what reason it's placed in comment? [code] //DataConn.ConnectionString="Provider=WinCCOLEDBProvider.1;Catalog="+DatabaseName+";DataSource="+ServerName+"\\WinCC" [/code] About the seconds: When you open the View your self by use of the Enterprise manager, are there then any seconds listed within the column DateTime? with regards, Ikkezelf
Ikkezelf Posts: 1084 Rating: (72)	Last edited by: Ikkezelf at: 11.06.2007 17:19
Suggestion To thank Quote Answer

6/12/2007 1:00 PM	Rate (0)
mara Posts: 62 Rating: (2)	Connectionstring is set in other place. I am sorry, i forgot to mention it. About seconds - I had used DataGridView object to show data, problem was in DefaultCellStyle - it was formatted (by default) to not show seconds. I set up custom formatting and everything is fine. But can someone explain me why this select does not work: SELECT PText1 FROM AlgViewRus; I get only error when I tried to execute this statement. This: SELECT * FORM AlgViewRus; works fine. (I can select only all columns). Thank You!
mara Posts: 62 Rating: (2)
Suggestion To thank Quote Answer

6/14/2007 7:25 PM	Rate (0)
Salma Gold Member Joined: 9/27/2005 Last visit: 11/27/2007 Posts: 1398 Rating: (150)	The problem is that the WinCC OLEDB Provider is not using native SQL. Instead it is using a propietary query language and you are limited in what you can modify. The Connectivity Pack manual provides a full explanation and breakdown on what queries can be used. So the first part of your query will always be "ALARMVIEW:SELECT * FROM". The view can be changed to return results in different languages and you are able to add multiple WHERE clauses. Salma

Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Follow us on