# Connection to Wincc OLEBD provider

**URL:** <https://forum.inductiveautomation.com/t/connection-to-wincc-olebd-provider/86510>\
**Category:** Ignition\
**Created:** [February 28, 2024, 1:26pm UTC](https://forum.inductiveautomation.com/t/connection-to-wincc-olebd-provider/86510 "2024-02-28T13:26:35Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rudi\_Putzeys](https://avatars.discourse-cdn.com/v4/letter/r/f475e1/32.png) [@Rudi\_Putzeys](https://forum.inductiveautomation.com/u/Rudi_Putzeys)\
**Post date:** [February 28, 2024, 1:26pm UTC](https://forum.inductiveautomation.com/t/connection-to-wincc-olebd-provider/86510/1 "2024-02-28T13:26:35Z")

</div>

We are struggling with building a connection from Ignition to the WinCC OLEDB provider to get alarms and alarmconfigs out of WinCC (v7.5)  
As far as I know there is no such a thing as a WinCC OLEDB for Ignition or jython, nor can I find how to build a connection to provider of WinCC  
Our collegues from WinCC suggested to build a ADO-connection in a script so they could use the same format queries/connection string as they use in scripting in WinCC, but I can't figure the whole thing out.

Any idea how we can build this connection?

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [February 28, 2024, 1:31pm UTC](https://forum.inductiveautomation.com/t/connection-to-wincc-olebd-provider/86510/2 "2024-02-28T13:31:29Z")

</div>

You might have luck standing up a SQL Server instance and then creating a linked server to this WinCC OLE DB.

> **[Create linked servers - SQL Server](https://learn.microsoft.com/en-us/sql/relational-databases/linked-servers/create-linked-servers-sql-server-database-engine?view=sql-server-ver16)**
>
> Create linked servers (SQL Server Database Engine)

---

<div class="post-metadata">

**Author:** ![Rudi\_Putzeys](https://avatars.discourse-cdn.com/v4/letter/r/f475e1/32.png) [@Rudi\_Putzeys](https://forum.inductiveautomation.com/u/Rudi_Putzeys)\
**Post date:** [February 29, 2024, 12:51pm UTC](https://forum.inductiveautomation.com/t/connection-to-wincc-olebd-provider/86510/3 "2024-02-29T12:51:00Z")

</div>

Hi Kevin, that was also one of our tries.  
Unfortunately does WinCC change their dataconnectionname (database) each time the project is compiled. 😔  
So, to make sure we're connecting to the right DB, the connection string should be dynamic...