MDAC 2.5 SDK - OLE DB Providers
OLE DB Provider for SQL Server


 

Installing the OLE DB Provider for SQL Server

The Microsoft® OLE DB Provider for SQL Server (SQLOLEDB) is installed automatically when you install Microsoft SQL Server™. If custom installation is done, the provider is installed when any of the following components are selected in the custom installation:

SQLOLEDB Files

Files necessary to develop SQLOLEDB consumers are installed when the appropriate option is selected during custom setup. Several SQLOLEDB sample applications ship with SQL Server. The samples implement simple SQLOLEDB consumers in C++.

Directory File Description
\Program files\
Common files\System\
Ole db
Sqloledb.dll Dynamic-link library that implements the SQLOLEDB provider
\Mssql7\DevTools\Include Oledb.h OLE DB header file (in MDAC SDK) for OLE DB providers and consumers
  Sqloledb.h Header file used for developing SQLOLEDB consumers
\Mssql7\DevTools\Lib Oledb.lib Library file used for developing SQLOLEDB consumers

MDAC SDK

The primary source of information for OLE DB is the OLE DB Programmer’s Reference available with the Microsoft Data Access Components (MDAC) SDK.

SQL Server does not install the MDAC SDK. To develop OLE DB applications, you need to install the MDAC SDK. For installation information, see the Universal Data Access Web site at www.microsoft.com/data.

See Also

"Overview of Installing SQL Server" in SQL Server Books Online

"Overview of Installing SQL Server" in Microsoft SQL Server Introduction