|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
ado vs oledbADO.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. -- Show quote____________________________________ 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@TK2MSFTNGP02.phx.gbl... > what is the difference between oleDB and ADO.net provider ? > 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 ? Show quote "William (Bill) Vaughn" <billvaRemoveT***@nwlink.com> wrote in message news:O3$qYYS$GHA.4356@TK2MSFTNGP05.phx.gbl... > 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@TK2MSFTNGP02.phx.gbl... >> what is the difference between oleDB and ADO.net provider ? >> > > 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 -- Happy Coding! Morten Wennevik [C# MVP] 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 Show quote "Morten Wennevik" <MortenWenne***@hotmail.com> wrote in message news:op.tib4dewsklbvpo@tr024.bouvet.no... > 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 > > > -- > Happy Coding! > Morten Wennevik [C# MVP] this product has to be purchased before it can be fully tested in asp.net ....
Show quote "Morten Wennevik" <MortenWenne***@hotmail.com> wrote in message news:op.tib4dewsklbvpo@tr024.bouvet.no... > 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 > > > -- > Happy Coding! > Morten Wennevik [C# MVP] 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. -- Show quote____________________________________ 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:uiF8pTT$GHA.1200@TK2MSFTNGP02.phx.gbl... > 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 ? > > > "William (Bill) Vaughn" <billvaRemoveT***@nwlink.com> wrote in message > news:O3$qYYS$GHA.4356@TK2MSFTNGP05.phx.gbl... >> 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@TK2MSFTNGP02.phx.gbl... >>> what is the difference between oleDB and ADO.net provider ? >>> >> >> > > 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. -- Show quoteGregory A. Beamer MVP; MCP: +I, SE, SD, DBA http://gregorybeamer.spaces.live.com ************************************************* Think outside of the box! ************************************************* "Jon Paal" <Jon[ nospam ]Paal @ everywhere dot com> wrote in message news:ODa5mDS$GHA.3860@TK2MSFTNGP02.phx.gbl... > what is the difference between oleDB and ADO.net provider ? >  |
|||||||||||||||||||||||
Other interesting topics