K-State CIS 764 - Microsoft Data Access Components (15 pages)

Previewing pages 1, 2, 3, 4, 5 of 15 page document View the full content.
View Full Document

Microsoft Data Access Components



Previewing pages 1, 2, 3, 4, 5 of actual document.

View the full content.
View Full Document
View Full Document

Microsoft Data Access Components

41 views

Other


Pages:
15
School:
Kansas State University
Course:
Cis 764 - Database Design
Database Design Documents

Unformatted text preview:

CIS 764 Presentation Somil Chandwani With Microsoft Data Access Components MDAC developers can connect to and use data from a wide variety of relational and nonrelational data sources You can connect to many different data sources using ActiveX Data Objects ADO Open Database Connectivity ODBC or OLE DB ADO ActiveX Data Objects ADO provides a high level programming model that will continue to be enhanced Although a little less performance than coding to OLE DB or ODBC directly ADO is straightforward to learn and use and it can be used from script languages such as Microsoft Visual Basic Scripting Edition VBScript or Microsoft JScript OLE DB OLE DB is a comprehensive set of COM interfaces for accessing a diverse range of data in a variety of data stores OLE DB providers exist for accessing data in databases file systems message stores directory services workflow and document stores OLE DB core services although not every OLE DB provider is available on the 64 bit Windows operating system ODBC The Microsoft Open Database Connectivity ODBC interface is a C programming language interface that allows applications to access data from a variety of Database Management Systems DBMS Applications that use this API are limited to accessing relational data sources only ODBC is available on the 64 bit Windows operating system ADO NET is an evolutionary improvement over traditional ADO for creating distributed data sharing applications It is a high level application programming interface that is targeted at loosely coupled n tier Internet based applications that support disconnected access to data It is a core component of the Microsoft NET Framework ADO NET provides consistent access to data sources such as Microsoft SQL Server and XML as well as to data sources exposed through OLE DB and ODBC Data sharing consumer applications can use ADO NET to connect to these data sources and retrieve manipulate and update the data that they contain Leverage current ActiveX Data Objects ADO



View Full Document

Access the best Study Guides, Lecture Notes and Practice Exams

Loading Unlocking...
Login

Join to view Microsoft Data Access Components and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view Microsoft Data Access Components and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?