Re: Is TDS used only if server is local?

From: Brett (no_at_spam.net)
Date: 01/04/05 

Date: Mon, 3 Jan 2005 23:52:29 -0500

It sounds as though you are saying the driver is used in all cases. On page
706 of 'Programming Microsoft Visual Basic .NET' version 2003, these
ADO.NET drivers are listed:

- OLE DB .NET
- SQL Server .NET
- ODBC .NET
- .NET Data provider for Oracle
- SQLXML Library

In reference to SQL Server .NET Data Provider, here is what the author says,
"This provider has been specifically written to access SQL Server 7 or later
using Tabular Data Stream (TDS) as the communication medium. TDS is SQL
Server's native protocol, so you can expect this provider to give you better
performance than the OLE DB Data Provider."

If TDS is always behind the scenes, why does the author specifically mention
it for SQL Server .NET Data Provider? What is wrong with using the other
drivers vs. this one?

Thanks,
Brett

"William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message
news:eLrFxRh8EHA.1396@tk2msftngp13.phx.gbl...
> TDS is used by the underlying data drivers and providers. It's the ONLY
> "language" that SQL Server speaks so it's always used behind the
> scenes--whether your SS is on the local system or on one 70 miles away on
> the network somewhere.
>
> hth
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> __________________________________
>
> "Brett" <no@spam.net> wrote in message
> news:OoRH1bg8EHA.3376@TK2MSFTNGP12.phx.gbl...
>> In order to use TDS via ADO.NET, does the SQL Server need to be on the
>> same machine?
>>
>> If not, this will have to involve TCP/IP or named pipes correct? How
>> does TDS help in that case?
>>
>> Thanks,
>> Brett
>>
>
>

Relevant Pages

  • Re: Is TDS used only if server is local?
    ... TCP/IP or Named pipes is the "envelope" that delivers the TDS to and from ... TDS is what SQL Server understands!! ... >> Both SQLServer provider and OleDB provider use TDS eventually, ... >>> In reference to SQL Server .NET Data Provider, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Is TDS used only if server is local?
    ... TDS will work if the SQL Server is on a different machine, ... > Both SQLServer provider and OleDB provider use TDS eventually, ... >> In reference to SQL Server .NET Data Provider, ...
    (microsoft.public.dotnet.framework.adonet)
  • Transliteration failed exception writing a large Java Unicode char
    ... I have included the java code snippet. ... trying to write to the SQL Server database Cluster. ... TDS traffic being sent by the Web Server to the database server NODE2. ... Variable-length Unicode character data of n characters. ...
    (microsoft.public.sqlserver.server)
  • Re: ODBC Drivers
    ... Sql server is not there and that's the one I need. ... that from an installer for SQL Server, or from MDAC 2.8 SP1, unless you're ... Note that you can get ODBC drivers from many sources besides Microsoft. ... those data sources. ...
    (microsoft.public.data.odbc)
  • Re: DTS Designer Error in the DLL
    ... I went through numerous setup configurations for the drivers and would you ... I currently have it working on a SQL Server 2000, ... "Scott Lindsey" wrote in message ... >>www.SQLDTS.com - The site for all your DTS needs. ...
    (microsoft.public.sqlserver.dts)