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:
· Server Components
· Management Tools
· Client Connectivity
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 SDK header file 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 |
The primary source of information for OLE DB is the OLE DB Programmer’s Reference Version 2.0 available with the OLE DB Software Development Kit (SDK). Both the SDK and Programmer’s Reference can be downloaded from the Microsoft Web site at http://www.microsoft.com/data.
SQL Server does not install the OLE DB SDK. To develop OLE DB applications, you need the OLE DB SDK from the Microsoft Web site.
Overview of Installing SQL Server