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

Viewing Siebel OLE DB Information


You can verify proper installation and troubleshoot problems with connecting to, or running queries with, Siebel OLE DB Provider and a Siebel data source.

To view Siebel OLE DB information

  1. Using Windows Explorer, right-click on each of the following OLE DB Provider DLLs.
    • bin\ssceolpr.dll
    • bin\ssceolwr.dll
    • bin\language\ssceolrs.dll

      Where:

      language is the Siebel code for the Language Pack you are installing for this server, such as enu for U.S. English.

  2. Select Properties from the pop-up menu.
  3. Select the Version tab in the Properties dialog.
  4. Verify that the fields have the appropriate values.

    NOTE:  You can also view this information within Siebel Tools and any COM-related development tool, such as the Object Browser in Microsoft Visual Studio.

About Siebel OLE DB and Multivalue Fields

Siebel allows you to create rowsets that contain multivalue fields (MVFs). However, when the rowset is issued in an OLE DB consumer such as MS Excel, only the first child record in the Siebel MVF field will be returned.

For instance, if you create a rowset based on the Opportunity BC and you add the Product MVF to the rowset, when you use the rowset in MS Excel only one record will display for each opportunity. The Product field or column will contain only the first product in the Multivalue fields list of products for the opportunity.

Transports and Interfaces: Siebel eBusiness Application Integration Volume III