The Database Forum

**s2002** · 05-31-2006, 06:38 AM

I do not know the appropriate connection string I should use to conect to MSSQL 2005.
Which of the following should I use?

SQL native client ODBC driver
SQL native client OLEB provider

**chrishirst** · 05-31-2006, 07:22 AM

OLEDB is the newer technology so may have more features or available properties

ODBC may be your only option for some DB servers.

**MyOpinion** · 05-31-2006, 02:24 PM

And the performance of OLEDB should be better than that of ODBC. So if you know the syntax for OLEDB, this choice should be better.