[Mono-list] OleDb Implementation

Rodrigo Moya rodrigo@ximian.com
Mon, 01 Sep 2003 21:18:57 +0200


On Mon, 2003-09-01 at 20:11 +0100, Mark Easton wrote:
> I'm trying to understand how Mono's implementation of the OleDb managed
> Provider works and thought I'd run things past the list to see if
> someone can either corroborate or correct my understanding.
> 
> The MS OleDb managed provider relies on Oledb drivers (which are
> technically known as OleDb providers) which must be implemented using a
> variety of COM interfaces and are therefore pretty much tied to the MS
> platform.
> 
> While the Mono OleDb managed provider externally appears to be
> equivalent to the MS managed provider, it is in reality a libGDA managed
> provider masquerading as the OleDb managed provider.  This means it can
> be used with any data sources for which there exists a libGDA provider.
> However, as a libGDA connection string is not identical with the
> equivalent OleDb connection string, if, for example, you wanted to port
> an MS.NET app that used OleDb to connect to postgres, at the very least
> you would have to change the connection string from the OleDb managed
> provider format to the libGDA provider format.
> 
I was planning to support MS OleDb's connection string format, so that
you can easily port applications from windows. The problem is that I ran
out of time, and since then I haven't been able to hack too much on
Mono.

But, yes, it was planned at that time. And if you really need it, it
would be great if you could add that compatibility layer.

cheers