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 <[email protected]> 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.... > > On Nov 5, 10:56 am, B☼gus Excepti☼n <[email protected]> wrote: > > > 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 > > :)
