ado vs oledb

[Jon Paal]

what is the difference between oleDB and ADO.net provider ?

 

[William \(Bill\) Vaughn]

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...

 

[Cowboy \(Gregory A. Beamer\)]

OleDb is a type of provider for ADO.NET. Of the many provider types, ODBC
and OLEDB are the more generic means of access. ODBC will work with any ODBC
compliant database engine, while OLEDB requires an OLEDB specific
driver/provider for the database you are attempting to access.

ADO.NET is a framework that includes OLEDB and other types of provider
libraries.

Not the best explanation, but it will do in a pinch.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com

*************************************************
Think outside of the box!
*************************************************

 

[Jon Paal]

so, if I wanted to talk to sqLite through ADO, I would need "sqliteClient" or I would need to get an oledb provider for SQLite ?

if I find an OleDB provider for SQLite then does it require installation on the server for usage ?

 

[Morten Wennevik]

Hi Jon,

There is no SQLite client in ADO.Net but you can use the OleDB client.
This page explains how to use oledb with sqlite.

http://luggle.com/~sean/Articles/sqlitePV.php

 

[Robert Simpson]

Actually, there's a great ADO.NET client for SQLite at:

http://sqlite.phxsoftware.com

Of course, it won't work with the OleDb framework he's trying to use, but
that's another matter.

Robert Simpson
Programmer at Large

 

[Jon Paal]

this product has to be purchased before it can be fully tested in asp.net ....

 

[William \(Bill\) Vaughn]

Most mainstream SQL databases have "native" .NET providers using managed
code. These are supplied by the DBMS vendor or can be purchased from 3rd
parties like Data Direct. It's best to use these native providers before
attempting to use a generic OLEDB provider--if you care about performance.

--
____________________________________
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...
-----------------------------------------------------------------------------------------------------------------------