----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Sachinsny Message 4 in Discussion Hi Melwyn, I guess you could say ODBC was version 1 of MS's quest for universal data access. It involves a standard API that uses "drivers" to access data. Depending on the driver used, it could be just a wrapper to a SQL DBMS client library, or it could actually have data parser functions built in (thus making it more of a data engine itself). If the database is just a file, then the driver was likely more of en engine, whereas, if the database was a server like Oracle, then the driver was more or less a wrapper for the DBMS client library. OLEDB was like version 2. OLEDB was a rethink that included more features, better performance, more modular organization of the API. You could access data sources using ODBC, or using OLEDB, or using ODBC, but wrapping it in the OLEDB API. MS started to obsolete ODBC, by coding MS SQL management tools to use only the OLEDB interface, instead of ODBC. ADO is an API for accessing and manipulating data gathered through an OLEDB or ODBC connection. It doesn't directly access data (well maybe text/xml). ADO.NET is like version 3 and is quite different from ADO v2.x. ADO.NET Data Providers are again, a new version of universal data access, that access data sources directly to gain performance advantages. ADO.Net also makes good use of XML standards to more effeciently transmit and cache data. It uses a more TCP-like connectionless metaphor so that all ADO.Net providers use sessionless connections. They get data and don't maintain a session on the server. DAO, RDO, ADO and OLE DB are data access methods that all accomplish exactly the same task. DAO - Data Access Objects (1-tier) Allow VB applications to talk to a database (the JET Engine) via ODBC. DAO was Microsoft's first object oriented solution for the manipulation of databases using the Jet Database Engine. The JET engine duplicates the functionalities of ODBC, and thus does not add much value. As the JET engine is generic, many of Oracle's features would not be accessible. Microsoft is currently phasing out this method. RDO - Remote Data Objects (2-tier) Allow VB applications to talk to a relational database (various Relational DBMSs) via ODBC. RDO is an interface to remote RDBMS via OBDC. One needs the Enterprise Edition of Visual Basic to use RDO. Microsoft is encouraging developers to migrate their RDO programs to ADO and OLE-DB. ADO - ActiveX Data Objects (1 to n-tier) Allow VB/Other Web Tools (Browsers) to interface with different kinds of data sources. ADO is a more recent Microsoft Data Access technology designed to replace DAO and RDO. ADO is designed to be simpler to use and more powerful than DAO/RDO. Serves an interface to Microsoft's new OLE-DB technology (thinner than ODBC). Can be used to access all sorts of "non traditional data" (e.g., web pages/documents, etc.). OLE DB data provider OLE DB is Microsoft's successor to ODBC that utilizes a set of COM interfaces for accessing and manipulating of data. Oracle implemented OLE DB as part of their "Oracle Provider for OLE DB" client software. It provides interface for both data-consuming applications and database providers. OLE DB is considered a thin middle layer which provides better data access performance. Summary RDO and DAO still works in VB for backwards compatibility. However, it is best to convert to ADO or OLE-DB. You can go thru this URL: http://www.thebestweb.com/db/dbaccesscode.asp http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag02/html/TheEvolutionofData-AccessTechnologies.asp It has plenty of information that you are looking for. Thanks, Sachin -----Original Message----- From: Melwyn D'Souza [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 7:12 PM To: [EMAIL PROTECTED] Subject: Regd ur post on BDOTNET Hi Sachin, This is regd ur post on BDOTNET on the subject Understanding data providers,data drivers, Odbc,oledb etc I found it very informative. I have a question. What is the difference between ODBC drivers, OleDB provider and .net data providers? Also how do ADO, DAO, RDO come into the picture? If u'd rather talk about it than write about, let me know ur phone no. :-) Regards, Melwyn -----Original Message----- From: Sachinsny [mailto:[EMAIL PROTECTED] Sent: Monday, June 28, 2004 6:04 PM To: BDOTNET Subject: Re: Understanding data providers,data drivers, Odbc,oledb etc New Message on BDOTNET Understanding data providers,data drivers, Odbc,oledb etc Reply Reply to Sender Recommend Message 2 in Discussion From: Sachinsny Basically its a standard or open application programming interface (API) for accessing a database. It can work as a bridge so by using the statements in a program, you can access files in a number of different databases, including Access, dBase, DB2, Excel, and Text. It allows programs to use SQL requests that will access databases without having to know the proprietary interfaces to the databases. It handles the SQL request and converts it into a request the individual database system understands. Let me know if you need more information. -Sachin -----Original Message----- From: Anjali_Mehta_DotNet [mailto:[EMAIL PROTECTED] Sent: Monday, June 28, 2004 5:28 PM To: [EMAIL PROTECTED]; PuneUserGroup; [EMAIL PROTECTED]; kolkatanet; [EMAIL PROTECTED]; MS Dot Net Indore; BDOTNET; [EMAIL PROTECTED]; Chennai .NET User Group; dotNET User Group Hyd; MumbaiUserGroup Subject: Understanding data providers,data drivers, Odbc,oledb etc New Message on BDOTNET Understanding data providers,data drivers, Odbc,oledb etc Reply Reply to Sender Recommend Message 1 in Discussion From: Anjali_Mehta_DotNet If i understand correctly ODBC drivers, OleDB provider or .net data providers... are programs which are implemented by database vendors for us to able to use database from a front end program? or can some one give me simpler terms to understand .. please i may sound silly .. but i have signed up these groups to get advices . View other groups in this category. View other groups in this category. ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/BDotNet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
