Does SQL Server 2005 use ODBC for Windows clients/processes?

[B☼gus Excepti☼n]

I'm in a class where their sw uses SQL 2005. The documentation says
that the DB uses ODBC. I remember ODBC as being used by win clients
that need to access non-MS databases (MySQL, Oracle, Postgress, etc.).

I can't remember the native protocol, and it was actually not easy to
locate on MSDN.

Any thoughts? I'd love to put the editor in their place! :)

pat
:)

[gregarican]

There should be various options for connecting to a SQL 2005 db.
OleDB, SQL Native Client, etc. Check here for specifics -->
http://books.google.com/books?id=GJLlv9wJKtcC&pg=PA52&lpg=PA52&dq=sql+server+2005+connection+methods&source=bl&ots=piWhovB58j&sig=3pkBpbMweZ0GbkrZCt8o5syLbMk&hl=en&ei=A_fySrOJCsvZlAev-uyzAw&sa=X&oi=book_result&ct=result&resnum=8&ved=0CB4Q6AEwBw#v=onepage&q=sql%20server%202005%20connection%20methods&f=false.

[B☼gus Excepti☼n]

gregarican,

Thanks for writing. I understand that there are many options, but I
was asking how native win clients connect. For example, in VS you can
choose as a datasource ODBC or Native SQL (SQL Server) sources. There
are many things that are possible in native that are not in ODBC, such
as MARS, UDT, etc. and better SP integration. They clearly aren't the
same.

My question was more to the point of what protocol _is_ used when not
using ODBC, as in creating a win application in VS (where mostly all
of us do). The book I'm reading for this sw course says that win
clients connect to SQL 2005 via ODBC, and I hardly think that is true.

So does anyone know the protocol used?

TIA!

pat
:)

On Nov 5, 11:03 am, gregarican <greg.kuj...@gmail.com> wrote:
> There should be various options for connecting to a SQL 2005 db.

> OleDB, SQL Native Client, etc. Check here for specifics -->http://books.google.com/books?id=GJLlv9wJKtcC&pg=PA52&lpg=PA52&dq=sql....

[Raghupathi Kamuni]

http://msdn.microsoft.com/en-us/data/aa937733.aspx

http://msdn.microsoft.com/en-us/data/aa937707.aspx