Difference between revisions of "Data Access"
Jump to navigation
Jump to search
| Line 8: | Line 8: | ||
Microsoft offers several types of data access components (Microsoft Data Access Components – MDAC), which compound of | Microsoft offers several types of data access components (Microsoft Data Access Components – MDAC), which compound of | ||
| − | * ADO | + | * ActiveX Data Objects (ADO) |
| − | * | + | * Object Linking and Embedding Database (OLE DB) |
| − | * ODBC | + | * Open Database Connectivity (ODBC) |
[http://www.ozgrid.com/forum/showthread.php?t=28221&s=365cb6a3a47e0fd69f90e02aa1dc5d9f&p=143369#post143369 ozgrid] | [http://www.ozgrid.com/forum/showthread.php?t=28221&s=365cb6a3a47e0fd69f90e02aa1dc5d9f&p=143369#post143369 ozgrid] | ||
http://www.connectionstrings.com/excel/ | http://www.connectionstrings.com/excel/ | ||
[[Category:Technology]][[Category:Architecture]] | [[Category:Technology]][[Category:Architecture]] | ||
Revision as of 16:31, 5 February 2016
General
The Data Access Layer is the tier of an application, where the actual sources are connected. In opposite to the Data Abstraction Layer, where the developer interacts with the data model on a higher level of abstraction, the data access usually encompasses not only information about the data sources but also about the means of connection like driver details.
Microsoft
Microsoft offers several types of data access components (Microsoft Data Access Components – MDAC), which compound of
- ActiveX Data Objects (ADO)
- Object Linking and Embedding Database (OLE DB)
- Open Database Connectivity (ODBC)