http://msdn.microsoft.com/en-us/data/aa937733.aspx http://msdn.microsoft.com/en-us/data/aa937707.aspx
On Fri, Nov 6, 2009 at 12:17 AM, B☼gus Excepti☼n <[email protected]>wrote: > > 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 > > > :) >
