New Features in Microsoft Data Access Components 2'6 Prash Shirolkar Support Engineer Webdata Micros

1
New Features in Microsoft Data Access Components
2.6Prash ShirolkarSupport EngineerWebdataMicr
osoft Corporation
2
Overview

• Microsoft Data Access Components (MDAC) 2.6
  Architecture
• MDAC 2.6 stack
• Whats new in MDAC 2.6?
• Beyond MDAC 2.6
• Resources

3
MDAC 2.6 Architecture
SQLISAPI
SQL XML
4
MDAC 2.6 Stack

• New components
• SQL XML
• MSXML
• Components no longer in MDAC
• Jet, Jet ODBC, Jet OLE DB
• Microsoft Visual FoxPro ODBC

5
Whats New in MDAC 2.6?

• Support for SQL Server 2000 XML features
• Ability to load XML documents
• Optimized singleton selects
• Enhanced ADO error reporting
• Direct access to ADO MD Schema objects
• Smaller, more robust redistributable setup
• Revamped SDK

6
Whats New in MDAC 2.6? (2)Support for SQL 2000
XML Features

• Retrieve results as a stream of XML data
• SELECT FOR XML
• OpenXML
• Query the database using XML
• Xpath query
• XML template files

7
Whats New in MDAC 2.6? (3)Ability to Load XML
Documents

• Using OSP Provider
• Supports hierarchy
• Intended for client not middle-tier

8
Whats New in MDAC 2.6? (4)Optimized Singleton
Selects

• OLE DB Row object
• ADO Record object
• 10-15 percent performance gain
• Only available when using SQL OLE DB

9
Whats New in MDAC 2.6? (5)Enhanced ADO Error
Reporting

• More information beyond Errors Occurred
• New Status property on Field object

10
Whats New in MDAC 2.6? (6)Direct Access to ADO
MD Schema Objects

• Find Object without walking hierarchy
• New GetSchemaObject method on Catalog object

11
Whats New in MDAC 2.6? (7)Smaller, More Robust
Redistributable Setup

• 5 MB smaller than MDAC 2.5
• Fewer scenarios that cause reboot
• File in use detection
• Support for rollback

12
Whats New in MDAC 2.6? (8)Revamped SDK

• Uses Windows Installer
• New samples
• Updated tools
• New and updated documents

13
Beyond MDAC 2.6

• MDAC 2.6 SP1
• MDAC 2.6 64-bit version
• Next version of SQL Server

14
Beta Support

• Full newsgroup coverage
• 2,000 active customers
• Nominate through mdacbeta_at_microsoft.com alias

15
Resources

• Universal Data Access Site
• http//www.microsoft.com/data/
• MDAC 2.6 SDK
• http//www.microsoft.com/data/download.htm
• PSS Knowledge Base Search Site
• http//support.microsoft.com/search/
• XPATH Information
• http//www.w3.org/TR/xpath/

16
Resources (2)

• XML Information
• http//web3.w3.org/XML/
• XSL Information
• http//web3.w3.org/Style/XSL/
• SQL Server 2000 Books Online
• Essential XML by Don Box, John Lam, and Aaron
  Skonnard from the DevelopMentor Series

17
(No Transcript)