"Login Failed as OLE Automation is diabled" is raised when using COM Data Control on 8.1.1.9 and after (Doc ID 1603636.1)

Last updated on MAY 20, 2015

Applies to:

Siebel CRM - Version 8.1.1.9 [23016] and later
Information in this document applies to any platform.

Symptoms

This is a reproduce environment in case of SIA 8.1.1.9.

"Login Failed as OLE Automation is diabled" is raised when using COM Data Control on the following Environment. This issue is only reproduced with Local mode, not Server mode.
- Server: Windows Server + SIA 8.1.1.9
- Client: Windows 7 + Dedicated Client 8.1.1.9 + Microsoft Excel
- Macro References:
   - Siebel Business Object Interfaces Type Library
   - SiebelOLEDB 1.0 Type Library
   - Siebel Data BusObject Interfaces(sobjsrv.tlb)

- Sample Macro Script

- Error would be raised as follows.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms