
	Home > Ask the SQL Server Experts > Archive: SQL Server 2005 Questions & Answers > SQL Native Client

Ask The SQL Server Expert: Questions & Answers

EMAIL THIS

SQL Native Client

EXPERT RESPONSE FROM: Adam Machanic

		Pose a Question

		Other SQL Server Categories

		Meet all SQL Server Experts
		Become an Expert for this site

Expert advice on database development

Digg This! StumbleUpon Del.icio.us

QUESTION POSED ON: 02 December 2005
What is the SQL Native Client?

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	Microsoft SQL Server 2005
	End of life comes for SQL Server 2005 SP2, 2008
	SQL Server Reporting Services Fast Guide
	SQL Server Service Broker Tutorial and Reference Guide
	Tips for tuning SQL Server 2005 to improve reporting performance
	SQL Server consolidation: Why it's an optimization technique
	Parent-child dimensions in SQL Server 2005 with Analysis Services MDX
	Enforcing data integrity in a SQL Server database
	SSIS error message due to installation problem on SQL Server 2005
	Should you upgrade to SQL Server 2005 or SQL Server 2008?
	Basics for working with DATETIME and SMALLDATETIME in SQL Server 2005
	Microsoft SQL Server 2005 Research

.NET Development for SQL Server

Creating Windows PowerShell scripts to manage SQL Server 2008 instances

Manipulate column names in a SQL Server table

Code to restore SQL Server databases in VB.NET

Custom VB.Net scripting in SQL Server Integration Services

Retrieve images from SQL Server and store in VB.Net

Connect to SQL Server database with Visual Basics

Top 10 SQL Server development questions

Developing CLR database objects: 10 tips, 10 minutes

CLR architecture

CLR stored procedures

.NET Development for SQL Server Research

XML in SQL Server

Processing XML files with SQL Server functions

Top 10 SQL Server development tips of 2008

Manage traces in SQL Server 2005 Analysis Services with XMLA commands

Create a computed column in SQL Server using XML data

Create DDL table in SQL Server 2005 to audit DDL trigger activity

Retrieve XML data values with XQuery in SQL Server 2005

XML data type in SQL Server 2005 vs. VARCHAR (MAX)

T-SQL commands vs. XML AUTO in SQL Server

Basic Transact-SQL programming constructs: 15 tips, 15 minutes

T-SQL identifiers

RELATED GLOSSARY TERMS

Terms from Whatis.com − the technology online dictionary

application server (SearchSQLServer.com)

Yukon (SearchSQLServer.com)

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

The SQL Native Client is a new OLE DB and ODBC API that provides data access providers with new functionality and datatypes provided by SQL Server 2005. By using SQL Native Client, applications can make use of features such as Multiple Active Result Sets (MARS), SQL Server 2005's XML datatype and CLR user-defined datatypes, and SQL Service Broker.

Developers using .NET languages such as C# or VB.NET in conjunction with ADO.NET will not need to worry about the SQL Native Client—all of the features it exposes are present in the ADO.NET classes. However, developers programming COM-based applications that need to access SQL Server 2005 databases may wish to expand their functionality by using the SQL Native Client for data access.

Do you have comments on this Ask the Expert Q&A? Let us know.

Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.

Browse our Expert Advice
Operating Systems IT Management Networking Database	Security Servers and Storage Applications and Development Career Center

SQL Solutions - SQL Database Design

SEARCH

TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 2005 - 2009, TechTarget \| Read our Privacy Policy