SQL Native Client

Adam Machanic 3

What is the SQL Native Client?

Requires Free Membership to View

Login

By submitting you agree to receive email communications from
TechTarget and its partners. Privacy Policy Terms of Use.

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.

More News and Tutorials

Articles

Related glossary terms

Terms for Whatis.com - the technology online dictionary
- Yukon

This was first published in December 2005

Join the conversationComment

Share

Comments

Results

Contribute to the conversation

All fields are required. Comments will appear at the bottom of the article.

Back to top

More from Related TechTarget Sites

Business Analytics
Data Center
Data Management
Data Management UK
Oracle
Content Management
Windows Server

Business Analytics
- Mobile business intelligence applications: Not just a pretty interface
  
  Back-end factors such as network performance and server hardware are key elements of building an effective mobile business intelligence architecture.
- Growing use of mobile BI apps sparks need to downsize designs
  
  Mobile business intelligence adds new challenges for BI teams, especially in designing apps. Don't overdo it on data, say BI managers and analysts.
- Real-time data analytics aims to boost businesses' speed of thought
  
  Real-time business intelligence can help improve operational decisions by enabling BI to be done in business systems. Read about how to make it work.
Data Center
- Q&A; roundup: Advice from data center administration experts
  
  Getting good data center administration advice can be tough, so we've compiled some recent Q&A; discussions with experts from the field.
- Desktop market matures but VDI challenges remain
  
  Tools enable companies to reduce support costs, boost security and lower energy consumption, but more is needed to overcome VDI challenges.
- Cloud, converged systems make server hardware future murky
  
  Server hardware has ruled the data center landscape for many years, but may be usurped as enterprises embrace converged systems and other new tech.
Data Management
- EMC, Intel unveil new Hadoop distributions, but how many is too many?
  
  IT heavyweights EMC and Intel have entered the big data ring with new distributions of Hadoop, adding more contenders to an already crowded field.
- Data management platform adds analytics for digital marketers
  
  Data management platform Crowd Control puts more analytics power into the hands of digital marketers and media buyers.
- Motorcycle icon Yamaha updates dealer site with fast database drivers
  
  Database drivers are sometimes an afterthought. But JDBC drivers came to the fore when Yamaha Motor Europe rebuilt its e-commerce website for dealers.
DataManagement UK
- Big data roundtable webcast: gaining value from big data
  
  Roundtable discussion on business value of big data, chaired by Brian McKenna, Editor, SearchDataManagementUK, and featuring Mike Ferguson, Roxane Edjlali (Gartner), Joshua LeCure (GlaxoSmithKline).
- 2012 training courses: BI, data management, data warehousing
  
  Find out where to hone your business intelligence, data management and data warehouse skills with this list of training courses for 2012.
- Poor data quality: what is dirty data costing UK organisations?
  
  Poor data quality can have serious financial consequences for businesses. Read about the current state of data quality management at UK companies, including dirty data problems.
Oracle
- No ERP customization for you, says solar company to users in upgrade
  
  With a potential IPO on the horizon, Amonix had to upgrade its ERP system fast. So it prohibited any ERP customization.
- Oracle Database Appliance x3-2 due out Tuesday
  
  A major upgrade to the Oracle Database Appliance x3-2 gives it some of the Exadata platform's high-end features, although it isn't quite there yet.
- Weigh the benefits of Oracle on mainframe vs. x86
  
  Until recently, big databases always meant using big iron. But as software and hardware evolves, Oracle on mainframe is becoming less common.
Content Management
- Rich media flood pushes digital asset management strategy to forefront
  
  Without an effective plan for managing digital assets, the increasing digital content collected by organizations could end up being a real headache.
- Avoid the pitfalls of cloud collaboration management
  
  Analyst Tim Walters explains how to build a strong case for cloud collaboration management and how to avoid problems that pop up along the way.
- Podcast: Who should be in charge of an enterprise search deployment?
  
  Organizations looking to set up an effective enterprise search deployment need to carefully consider the person they pick to lead the initiative.
Windows Server
- Seven things to know about Windows Server 2012 deduplication
  
  It's no magic bullet, but Windows Server 2012 deduplication can help alleviate rising data storage demands.
- The greening of Windows Azure: Microsoft ready to take on AWS
  
  Microsoft's Windows Azure strategy -- integration with System Center 2012 and a low price -- make it a viable alternative to AWS for cloud computing.
- Overcoming Server Core installation woes in Windows Server 2012
  
  Don't run away from a Server Core installation in Windows Server 2012. Follow these simple steps for a successful transition.

All Rights Reserved,Copyright 2005 - 2013, TechTarget