Installing the OLE DB Provider for SQL Server

OLE DB and SQL Server

OLE DB and 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™ 2000. In a custom installation, the provider is installed when any of the following components are selected:

  • Server Components

  • Management Tools

  • Client Connectivity
SQLOLEDB Files

Files necessary to develop SQLOLEDB consumers are installed when the appropriate option is selected during a custom installation; several SQLOLEDB sample applications are included. The samples implement SQLOLEDB consumers in C++.

Directory File Description
Program files\Common files\System\Ole db Sqloledb.dll Dynamic-link library that implements the SQLOLEDB provider.
Program Files\Microsoft SQL Server\80\Tools\DevTools\Include Oledb.h OLE DB SDK header file for OLE DB providers and consumers.
Program Files\Microsoft SQL Server\80\Tools\DevTools\Include Sqloledb.h Header file used for developing SQLOLEDB consumers.
Program Files\Microsoft SQL Server\80\Tools\Dev Tools\Lib Oledb.lib Library file used for developing SQLOLEDB consumers.

OLE DB SDK

The primary source of information for OLE DB is the OLE DB Software Development Kit (SDK), which can be downloaded from Microsoft Web site.

The OLE DB SDK is not installed with SQL Server 2000. To develop OLE DB applications, you need the OLE DB SDK from Microsoft Web site.

See Also

Overview of Installing SQL Server 2000