Bookshelf Home | Contents | Index | PDF     

Transports and Interfaces: Siebel eBusiness Application Integration Volume III > Using Siebel OLE DB Provider >

Installing the Siebel OLE DB Provider

You can install the Siebel OLE DB Provider standalone from the Siebel Server CD-ROM. By selecting the custom EAI installation, you can install the OLE DB Provider as a stand-alone client.

Siebel OLE DB Provider must be installed on the same system where the OLE DB Consumer has been installed. The DB Consumer can be installed on either the Siebel Server or one of the Siebel Web Clients.

To use Siebel OLE DB Provider with Microsoft SQL, the full version of Microsoft SQL Server must be installed and operational. To create an Active Server Page (ASP) application, the Siebel OLE DB Provider and Microsoft IIS must be installed and operational.

The OLE DB Consumer used depends on how the Siebel OLE DB Provider is accessed:

  • When accessing the Siebel OLE DB Provider from ASP pages (this includes access from the client application Internet Explorer or other Web browser), IIS is the OLE DB Consumer.
  • When accessing the Siebel OLE DB Provider from SQL Server (this includes access from the client application Query Analyzer), SQL Server is the OLE DB Consumer.
  • When accessing the Siebel OLE DB Provider from Excel or Access, Excel or Access is the OLE DB Consumer.

The Siebel OLE DB Provider is installed as a default interface within the Siebel Mobile Client and the Siebel Server applications. You can also install this on different systems using the custom EAI install from Siebel Server. The Siebel OLE DB Provider supports the following OLE DB and ActiveX Data Object (ADO) foundation versions:

  • Microsoft OLE DB
  • Microsoft ADO

The required base-level operating systems validated for the use of Siebel Systems products contain the necessary foundation versions of OLE DB and ADO to support the Siebel OLE DB Provider. See the System Requirements and Supported Platforms on Siebel SupportWeb for further information.

This section covers the following topics:

    
Transports and Interfaces: Siebel eBusiness Application Integration Volume III