Re: ado vs oledb

ADO.NET is a data access interface that uses any number of .NET data
providers including SqlClient (to talk to SQL Server), SqlCe (to talk to SQL
Server Compact Edition), OracleClient (to talk to Oracle) and OSFA providers
like Odbc and OleDb which require ODBC drivers or OLEDB data providers to
talk to a variety of backends.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
Between now and Nov. 6th 2006 you can sign up for a substantial discount.
Look for the "Early Bird" discount checkbox on the registration form...
-----------------------------------------------------------------------------------------------------------------------

"Jon Paal" <Jon[ nospam ]Paal @ everywhere dot com> wrote in message
news:ODa5mDS$GHA.3860@xxxxxxxxxxxxxxxxxxxxxxx
what is the difference between oleDB and ADO.net provider ?



.

Relevant Pages

  • Re: Enterprise Library - DataAccessApplicationBlock - MySql/DB2
    ... The fact that you set parameters differently for different providers isn't ... Oracle or Microsoft told me "We don't like the way you did that", ... ISDATE doesn't produce the same results in both Sql Server ... and Oracle both have a ton of specific features that others don't have. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Can you use the OleDb classes for SQL Server?
    ... William Vaughn ... Hitchhiker's Guide to Visual Studio and SQL Server ... I didn't mean using the same stored procedures for different RDBMSes. ... William it's better to use abstraction in the code such as providers and i ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Connection to SQL Server on Vista
    ... The OP is using SQL Server 2000 not 2005. ... build versions and are now called "Data Access Components". ... In addition just telling someone to change providers with a working app is ... own providers so we will have SNAC, DAC (er, MDAC), and "ONAC". ...
    (microsoft.public.vb.database.ado)
  • Re: Error using OPENROWSET
    ... SQL Server does not allow ad hoc distributed queries using ... OPENROWSET and OPENDATASOURCE against providers other than the SQL Native ... Client OLE DB Provider. ... Check the "Ad Hoc Distributed Queries Option" topic in Books OnLine. ...
    (microsoft.public.sqlserver.datamining)
  • Re: What happened to SqlConnection.BeginOpen?
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... Between now and Nov. 6th 2006 you can sign up for a substantial discount. ... Queuing things to a background worker thread won't do any good. ... can easily see us in high load conditions wanting to queue up 1000 db ...
    (microsoft.public.dotnet.framework.adonet)