10/22/2015 10:49 AM | |
Posts: 8 Rating: (0) |
Hi, I have some questions and problems with Industrial Data Bridge. About software, I work with Tia Portal Professional (Step 7 and WinCC), WinCC RT Professional and IDB v7.3.
I want to connect WinCC to MySQL with IDB. Firstly I did the XML. I followed the instructions about how to do this with TIA Professional (Data Transmission from WinCC Runtime Professional with the help of IndustrialDataBridge).
I created a new project in IDB. I set WinCC OLEDB as provider and Data Base as Consumer.
In Provider configuration I choose my XML file and my “WinCC station Name”. In Consumer configuration I set MySQL. In server I write my local host (127.0.0.1), in “User name” root. I choose “Blank Password” because MySQL doesn’t have authentication. ***Attachment Screenshot_1
When I tried to select a database in the drop-down menu. It doesn’t show nothing:
***Attachment Screenshot_2
What’s wrong?
On the other hand I created my MySQL DataBase (siwa) with a table (valores_siwa). This table has 4 columns (Id, name, value and Date).
***Attachment Screenshot_3
I define a procedure. It has 3 inputs. These inputs are the names of 3 columns I want to fill.
***Attachment Screenshot_4
I am not sure about this procedure because there are little information about it works in the help. I don’t know if this is the way to IDB works.
In resume, I can’t chose the Database (I think that there is not communication between IDB and MySQL). Secondly I don’t know if this procedure I made is ok. Any body can help me?
Best, Fran. |
10/22/2015 1:43 PM | |
Posts: 8 Rating: (0) |
Yes, programs, keyboard, lenguage. Everything that the Data
Transmission from WinCC Runtime Professional with the help of
IndustrialDataBridge explains in chapter 2. Requirements. |