The Wayback Machine - https://web.archive.org/web/20060324134243/http://staff.develop.com/bobb/sql2005book/changes11.htm

A First Look at SQL Server 2005 for Developers:

Chapter 11 Changes

    This page is devoted to changes to the product that affect the material in the book "A First Look at SQL Server 2005 for Developers" by Bob Beauchemin, Niels Berglund, and Dan Sullivan. You can report errata by mailing bobb@develop.com.

bulletProduct changes reported as of July 26, 2004
LocationDescription
 SQL Server 2005 Beta 1 shipped with a new version of MDAC (the Microsoft Data Access Components), MDAC version 9.0. Just before the book shipped, MDAC 9.0 was removed from the SQL Server distribution. MDAC will now ship as part of the base operating system and will be updated with operating system service packs.

Instead, a new product, SQL Native Client, ships with SQL Server 2005 Beta 2. This product included a DLL (SQLNCLI.dll) that contains a new OLE DB provider and a new ODBC driver for SQL Server. In order to use the new SQL Server 2005 functionality, such as Multiple Active Resultsets, from OLE DB or ODBC clients, the new provider/driver must be used.

We removed the material on MDAC 9.0 from this chapter of the book, but did not add information about SQL Native Client. A short description of SQL Native client can be found on my weblog, here.

Because there is not a new version of MDAC at this time, the OLE DB and ADO support for UDTs, the XML data type, and large value (MAX) data type is not integrated as it was in MDAC 9.0. The SQL Server 2005 Beta 2 readme file indicates "This functionality will be available to ADO in future versions of SQL Native Client." We'll post an update here when a new version of MDAC ships.

Page 394-396MDAC Version 2.8 SP1 does not support Field.BindType or the adBindType enumeration. This support was in MDAC 9.0 shipped with SQL Server 2005 Beta 1. MDAC 9.0 was removed from Beta 2. You cannot bind a UDT column in ADO as an object or variant, as the book states. This may be addressed in the next beta of a new version of SQL Native Client (SNAC), when using the OLE DB provider SQLNCLI.
Page 402-403MDAC Version 2.8 SP1 does not support Field.BindType or the adBindType enumeration. This support was in MDAC 9.0 shipped with SQL Server 2005 Beta 1. MDAC 9.0 was removed from Beta 2. You cannot bind an XML data type column in ADO as an object or variant, as the book states. This may be addressed in the next beta of a new version of SQL Native Client (SNAC), when using the OLE DB provider SQLNCLI.
Copyright 2004, Bob Beauchemin, Niels Berglund, Dan Sullivan
close