Home / server / Questions / 127228
Accepted
atricapilla
Asked: 2010-03-30 01:48:09 +0800 CST

Native SQL Server connection vs ODBC?

  • 772

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

sql-server odbc

1 Answers

  1. Best Answer

    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.

    • 1