I have an application which can connect to OLE DB data sources. But me proprietary database has only ADO.NET provider.

Is there any ADO.NET to OLE DB bridge which helps me to connect to ADO.NET data source?


You didn't mention the platform so I am going to assume things and point you to some direction.

For the .NET Framework Data Provider for OLE DB, the connection string format is identical to the connection string format used in ADO

For more details you can refer to this page to get started:

Connecting to an OLE DB Data Source Using ADO.NET

And also it wouldn't hurt to have a look at this title Connecting to an OLE DB Data Source in the following MSDN article (.NET 4.5)

Establishing the Connection


On the other hand to access a ADO.NET data source using an OLE DB you can follow this example.

However if you mean by the word "bridge" to have something like

using (SqlConnection connection = new SqlConnection(oleConnectionString))

where, oleConnectionString is an originally an OLE connection string which is converted to act as an SQL connection string?! I am not sure if that's possible.

ADO.NET Sample

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.