Database Reference
In-Depth Information
18.4.5 Code Samples
None of the code samples is installed by default. However, depending on your choice,
their inclusion could serve to enrich your SQL Server environment. The following are the
main options:
•
ADO includes programming examples for ActiveX
Data Objects (ADO).
•
DBLIB includes programming examples for the DB-Library API.
DB-Library was the native Database Application Programming
Interface (API) of SQL Server in earlier releases, and is supported
in SQL Server for backward compatibility.
•
Desktop includes code samples on setting up unattended install
operations for the Microsoft SQL Server Desktop Engine (MSDE).
•
DTS includes programming examples for data transformation
services (DTS). DTS provides a way to move data from one data
source to another.
•
ESQLC includes the programming examples for Embedded SQL
for the C programming language.
•
MSDTC includes the programming examples for the Microsoft
Distributed Transaction Coordinator.
•
ODBC includes the programming examples for the open database
connectivity programming API in SQL Server.
•
ODS includes the programming examples for the open data
services (ODS) API for SQL Server.
•
OLE Automation includes the programming examples to support
OLE Automation for SQL Server.
•
Replication includes the programming examples for
SQL Server replication.
•
SQLDMO includes programming examples for the SQL-Distributed
Management Objects administrative programming interface.
•
SQLNS includes programming examples for the SQL Name Space
administrative programming interface.
18.4.6 SQL Server Optional Components
After installing SQL Server, you can install three additional services: the Microsoft
Search Service, the Microsoft SQL Server Analysis Services, and Microsoft English Query.
Although you can the Microsoft Search Service (full-text indexing) during the default
setup of SQL Server, you also have the option of installing the other two services after the
initial setup is complete. This can be done independent of SQL Server if so desired.
