Oracle Objects for OLE -- Automation server / ActiveX component can't create object

Problem

While using Oracle Objects for OLE and trying to instantiate an OracleInProcServer.XOraSession object or any other object you get error like:

Microsoft JScript runtime error: Automation server can't create object

or

Microsoft VBScript runtime error: ActiveX component can't create object: 'OracleInProcServer.XOraSession'

Your operating system is 64-bit Windows.

Solution

The problem is that Oracle Objects for OLE is not supported on 64-bit Windows operating systems. But this doesn't mean that you can't use OO4O on 64-bit Windows operating systems.

To successfully run your scripts you have to use 32-bit Automation Servers, for example 32-bit Internet Explorer, 32-bit Microsoft Office products or 32-bit cscript.exe located in C:\Windows\SysWOW64

Reference:

• http://docs.oracle.com/cd/E11882_01/win.112/e17727/intro.htm#OOFOL118
• Oracle Objects For OLE Not Installed With 64bit Oracle Client 11gR2 (Doc ID 1178672.1)
• FAQ: Running 32-bit and 64-bit Oracle Software On 64-bit Windows (Doc ID 1151394.1) 
• Considerations Using The Oracle Client With Microsoft Products on 64 bit Windows Operating System (Doc ID 781432.1)
• http://docs.oracle.com/cd/B28359_01/install.111/b32006/intro.htm#BABHDHHA