- Introduction to Data Access
Open Database Connectivity (ODBC) is a Microsoft standard for database access.
It provides a mechanism for desktop-based tools (word processors, spreadsheets, report writers, Internet/Intranet tools, etc.) to transparently access data sources such as databases.
A typical Single-Tier installation may consist of a database server and a client that comprises the client networking provided by the database engine vendor and the
- Microsoft Excel
- Microsoft Word
- Microsoft Access
- Crystal Report Writer
FrontPage98 (web page development tool)
- Visual Basic, Visual C++
- All Visual Studio ADO components
All standard Microsoft Office applications use the Microsoft Query tool to access data. This package must be installed in order for ODBC drivers to work. Microsoft queries can be embedded in documents and spreadsheets and easily reused and modified.
Here are just a few possibilities:
- Customize reports directly in Microsoft Excel
- Create (e-)mailing lists in Microsoft Word
- Write and design reports in Crystal Reports
- Create custom reporting tools or data monitoring tools (like
CorVu's Executive Alert) through applications written in Visual Basic, C++, Java, etc.
- Render on-line information using data driven web content.
- And much more.....
The Microsoft(R) Data Access SDK is the primary source of information, instructions, and utilities on use of data access technologies such as ODBC. It provides tools, samples, and documentation to help developers create solutions for their data access needs. For the latest news and updates about the data access technologies, go to the Microsoft Data Access Web site http://www.microsoft.com/data/
The MSDASDK contains a complete programmers' reference guide to ODBC, as well as other data access technologies.
An online version is available at the MSDN site.
Direct API testing applications are also available in the MSDASDK.