Skip to Main Content
Programming SQL Server 2005
book

Programming SQL Server 2005

by Bill Hamilton
February 2006
Intermediate to advanced content levelIntermediate to advanced
586 pages
17h 35m
English
O'Reilly Media, Inc.
Content preview from Programming SQL Server 2005

Chapter 6. .NET Client-Side Programming

This chapter describes SQL Server 2005 client-side programming technologies. These include:

SQL Native Client programming

Replaces the SQL OLE DB and SQL ODBC drivers; uses Microsoft Data Access Components (MDAC) and implements functionality supporting new features in SQL Server 2005.

SQLXML 4.0

Updates SQLXML 3.0 to accommodate new features in SQL Server 2005.

Exception Message Box programming

Extends the functionality of the regular message box in the System.Windows.Forms.MessageBox class to make it easier for you to control and to provide detailed information to users.

SQL Native Client Programming

Microsoft SQL Server 2005 introduces SQL Native Client, which is designed to simplify native access to data in SQL Server 7.0 or later using either OLE DB or ODBC. SQL Native Client replaces the SQL OLE DB provider and the SQL ODBC driver with a standalone API that combines both the SQL OLE DB provider and SQL ODBC driver functionality into a single DLL. The individual data access technologies are now referred to as SQL Native Client (OLE DB) and SQL Native Client (ODBC). Additionally, SQL Native Client supports new SQL Server 2005 enhancements, as described in Table 6-1.

Table 6-1. SQL Native Client support for new functionality in SQL Server 2005 (continued)

Function

Description

xml data type

Supports the SQL Server 2005 xml data type for columns, variable, parameters, and return types

Large value types

Supports SQL Server large-object data ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Programming Microsoft® SQL Server® 2012

Programming Microsoft® SQL Server® 2012

Leonard Lobel and Andrew Brust

Publisher Resources

ISBN: 0596004796Supplemental ContentErrata Page