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?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
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:
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)
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))
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.