Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

What is the difference between native SQL Server connection and ODBC? What are the benefits when using native SQL Server connection?

share|improve this question
up vote 1 down vote accepted

When possible, you should always use Sql Native Client, or the Native Sql Data Provider. It is far more superior in terms of performance than an ODBC connection.

ODBC is basically another layer of abstraction. It might be interesting if you want to support different databases and to switch them at run-time, but if you're sure you're going to stick with Sql Server, Native Client is the way to go.

share|improve this answer
Is the performance only thing you should consider when deciding which connection method to use? – atricapilla Mar 29 '10 at 11:57
@jrara: No, you should first consider if you need the extra abstraction layer, so if you need to be able to easily switch databases later. If that is not the case, there's no point in using ODBC. – fretje Mar 29 '10 at 12:43
Ok, thanks!.... – atricapilla Mar 29 '10 at 12:45

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.