Bookshelf Home | Contents | Index | Search | PDF

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

Viewing 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 OLE DB information

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.

Select Properties from the pop-up menu.
Select the Version tab in the Properties dialog.
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.

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.

Bookshelf Home | Contents | Index | Search | PDF