Re: Is ADO.NET OleDb .NET Data Provider a COM object?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Ah, first, COM is simply the interface, not the objects to which it connects.

I recommend that you give up on COM-based ADO if you're working with a .NET language. (period)

Yes, I expect there are MySQL ODBC drivers and there are MySQL .NET native providers. I found one here http://dev.mysql.com/downloads/connector/net/5.0.html. There might be others. I would (always) recommend a .NET native provider over an OLE DB (or ODBC) provider. As I discuss in my latest book, using ODBC drivers to access databases is also faster and less trouble-prone than OLE DB as the interface is (again) managed code.

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker’s Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________



"Mark Worsnop" <MarkWorsnop@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:278F2FC8-3B41-4139-9E53-CC9F90FFD8F5@xxxxxxxxxxxxxxxx
So if I want my application to be able to use SQL server or MySql for
example, the only choice I have is using the OleDB, is that correct. I do
know there are differences in the way you talk to the DB regardless of how
you get there.

If I do us the OleDB and that uses the COM wrapper, then I might as well
use the COM that I used in VB6 too or are they different.

As there is no other way to access MySql other than the OleDB am I to assume
that its ok to use this? Is there another choice?

Thanks for all your input!

.

Relevant Pages

  • Re: Really want a answer, is there a mature way to access different data providers without performan
    ... >> You can use OleDB and ODBC also. ... >> direct adapter as SqlClient. ... interface, but I am still not sure if accessing sql ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cisco Netflow Analzyer
    ... I am looking at the PRTG software not happy with the interface. ... I can recommend the first, and we're using an old copy, not sure how ... Solarwinds' product is just stupidly expensive iirc, ... Scrutinizer does that pretty well from what I've been lead ...
    (comp.dcom.sys.cisco)
  • Re: need help with Cisoc vpn 3015
    ... > have an extra interface on the Pix 515e for the VPN. ... I do not know about Cisco "recommened" design, ... To my knowlegde Cisco's recommadation is to have both interface on a DMZ. ... Call it unofficial recommend, if you like. ...
    (comp.dcom.sys.cisco)
  • Re: Apple Computer sides with Satan
    ... >>Because I prefer the features and interface provided by Windows, ... >>naturally recommend it to my clients. ... >A good consultant don't just recommend to others what he likes best himself. ... It is the features I can offer with Windows ...
    (sci.astro.amateur)
  • Re: On the use of interface in F95
    ... but I'm not going to recommend that ... interface operator ... end module myoperator ...
    (comp.lang.fortran)