| Hal Berenson 2002-12-21, 7:25 pm |
| SQL Server is protocol rather than API based. The API is called Tabular
Data Stream, or TDS. There are two major forms of communication in TDS,
Database RPC calls and SQL Language calls. SQL Language calls use the
Transact-SQL dialect of SQL. There are two current Native APIs (meaning
that the API implementation talks directly to TDS), ODBC and OLE DB.
There is one Native Object Model, ADO.Net's System.Data.SQLClient, that also
talks directly to the server via TDS. All three native mechanisms provide
facilities for calling Stored Procedures directly via Database RPC calls and
sending in SQL commands via SQL Language calls. Metadata calls in these
APIs translate into Database RPC calls to server-side stored procedures
specifically written to meet the metadata needs of each client. The
APIs/object model also provide client specific features that make it easier
to deal with the large sets of data that may be returned from the server.
There are numerous object models that talk to SQL Server via ODBC or OLE DB.
RDO uses ODBC, ADO and System.Data.OleDb use OLE DB.
There in an older APIs, DB-Library, that was the original native API. But
it now communicates with SQL Server through a translation layer (built into
the server) and can't express many SQL Server features. So I don't consider
it native. There are older object models as well, but none that are native.
TDS itself is undocumented and writing your own TDS application is
unsupported. Unless you are trying to do something like write a SQL Server
API for Linux, don't even think of going to the TDS level. And if you are
thinking of something like that, do a Google search for FreeTDS and save
yourself some trouble.
--
Hal Berenson
True Mountain Consulting
"Joe Reazor" <joenospam@belgor.com> wrote in message
news:eXiueSEqCHA.1876@TK2MSFTNGP10...
> What is the native language of SQL Server? Meaning what do all queries
and
> other commands that come in through OLE DB or ODBC or ADO or even T-SQL
get
> translated to behind the scenes?
>
> ==============
> Joe Reazor
> Gorbel Inc.
> email: joereaATgorbelDOTcom
>
>
|