Re: Is TDS used only if server is local?

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

Date: Tue, 4 Jan 2005 06:30:41 -0500

TDS will work if the SQL Server is on a different machine, in which case
TCP/IP or named pipes must be used?

Thanks,
Brett

"Sahil Malik" <contactmethrumyblog@nospam.com> wrote in message
news:ezlKNth8EHA.2700@TK2MSFTNGP14.phx.gbl...
> As Bill Vaughn said, TDS is what SQL Server understands!!
>
> Both SQLServer provider and OleDB provider use TDS eventually, but the
> OleDB provider has to go through a bunch of complicated interfaces on your
> local machine before it gets to TDS - which is why the performance hit.
>
> - Sahil Malik
> http://dotnetjunkies.com/weblog/sahilmalik
>
>
>
> "Brett" <no@spam.net> wrote in message
> news:OMj6zkh8EHA.2552@TK2MSFTNGP09.phx.gbl...
>> 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?
    ... Even if it was so small, do you have a reason to prefer ODBC to the .NET ... I would see things the other way round, using the .NET provider unless I ... If TDS are the actual data, ... CFMX accessing SQL Server stored procedures via ODBC SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Is TDS used only if server is local?
    ... TDS is what SQL Server understands!! ... Both SQLServer provider and OleDB provider use TDS eventually, ... > you better performance than the OLE DB Data Provider." ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Is TDS used only if server is local?
    ... ADO.NET drivers are listed: ... In reference to SQL Server .NET Data Provider, here is what the author says, ... TDS is SQL ...
    (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: 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)